import sqlite3
import sys
from PyQt5.QtWidgets import QApplication, QWidget
from PyQt5.QtWidgets import QMessageBox
from PyQt5 import QtCore, QtWidgets
import shipment_edit
import shipment_add
from PyQt5 import QtCore, QtGui, QtWidgets


class Ui_Form(object):
    def setupUi(self, Form):
        Form.setObjectName("Form")
        Form.resize(1210, 687)
        self.label_13 = QtWidgets.QLabel(Form)
        self.label_13.setGeometry(QtCore.QRect(470, 10, 161, 61))
        self.label_13.setObjectName("label_13")
        self.lineEdit_search = QtWidgets.QLineEdit(Form)
        self.lineEdit_search.setGeometry(QtCore.QRect(80, 20, 71, 20))
        self.lineEdit_search.setObjectName("lineEdit_search")
        self.label_customer1 = QtWidgets.QLabel(Form)
        self.label_customer1.setGeometry(QtCore.QRect(150, 140, 191, 41))
        self.label_customer1.setObjectName("label_customer1")
        self.line_7 = QtWidgets.QFrame(Form)
        self.line_7.setGeometry(QtCore.QRect(50, 70, 1061, 20))
        self.line_7.setFrameShape(QtWidgets.QFrame.HLine)
        self.line_7.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_7.setObjectName("line_7")
        self.pushButton_SwitchCustomer = QtWidgets.QPushButton(Form)
        self.pushButton_SwitchCustomer.setGeometry(QtCore.QRect(1020, 20, 91, 23))
        self.pushButton_SwitchCustomer.setObjectName("pushButton_SwitchCustomer")
        self.label_4 = QtWidgets.QLabel(Form)
        self.label_4.setGeometry(QtCore.QRect(380, 90, 61, 39))
        self.label_4.setObjectName("label_4")
        self.pushButton_SwitchService = QtWidgets.QPushButton(Form)
        self.pushButton_SwitchService.setGeometry(QtCore.QRect(920, 20, 91, 23))
        self.pushButton_SwitchService.setObjectName("pushButton_SwitchService")
        self.label_8 = QtWidgets.QLabel(Form)
        self.label_8.setGeometry(QtCore.QRect(20, 22, 61, 20))
        self.label_8.setObjectName("label_8")
        self.label_5 = QtWidgets.QLabel(Form)
        self.label_5.setGeometry(QtCore.QRect(470, 90, 71, 39))
        self.label_5.setObjectName("label_5")
        self.label_2 = QtWidgets.QLabel(Form)
        self.label_2.setGeometry(QtCore.QRect(70, 90, 61, 39))
        self.label_2.setObjectName("label_2")
        self.pushButton_previous = QtWidgets.QPushButton(Form)
        self.pushButton_previous.setGeometry(QtCore.QRect(200, 650, 75, 23))
        self.pushButton_previous.setObjectName("pushButton_previous")
        self.pushButton_next = QtWidgets.QPushButton(Form)
        self.pushButton_next.setGeometry(QtCore.QRect(310, 650, 75, 23))
        self.pushButton_next.setObjectName("pushButton_next")
        self.pushButton_new = QtWidgets.QPushButton(Form)
        self.pushButton_new.setGeometry(QtCore.QRect(50, 650, 91, 23))
        self.pushButton_new.setObjectName("pushButton_new")
        self.lineEdit_jump = QtWidgets.QLineEdit(Form)
        self.lineEdit_jump.setGeometry(QtCore.QRect(640, 650, 31, 20))
        self.lineEdit_jump.setObjectName("lineEdit_jump")
        self.pushButton_jump = QtWidgets.QPushButton(Form)
        self.pushButton_jump.setGeometry(QtCore.QRect(700, 650, 41, 21))
        self.pushButton_jump.setObjectName("pushButton_jump")
        self.label_9 = QtWidgets.QLabel(Form)
        self.label_9.setGeometry(QtCore.QRect(600, 640, 91, 39))
        self.label_9.setObjectName("label_9")
        self.label_11 = QtWidgets.QLabel(Form)
        self.label_11.setGeometry(QtCore.QRect(1030, 90, 61, 39))
        self.label_11.setObjectName("label_11")
        self.label_14 = QtWidgets.QLabel(Form)
        self.label_14.setGeometry(QtCore.QRect(200, 90, 91, 39))
        self.label_14.setObjectName("label_14")
        self.label_shipDate1 = QtWidgets.QLabel(Form)
        self.label_shipDate1.setGeometry(QtCore.QRect(60, 150, 71, 21))
        self.label_shipDate1.setObjectName("label_shipDate1")
        self.label_production1 = QtWidgets.QLabel(Form)
        self.label_production1.setGeometry(QtCore.QRect(360, 150, 91, 21))
        self.label_production1.setObjectName("label_production1")
        self.label_model1 = QtWidgets.QLabel(Form)
        self.label_model1.setGeometry(QtCore.QRect(470, 150, 61, 21))
        self.label_model1.setObjectName("label_model1")
        self.label_15 = QtWidgets.QLabel(Form)
        self.label_15.setGeometry(QtCore.QRect(560, 90, 41, 39))
        self.label_15.setObjectName("label_15")
        self.label_macID1 = QtWidgets.QLabel(Form)
        self.label_macID1.setGeometry(QtCore.QRect(550, 150, 51, 21))
        self.label_macID1.setObjectName("label_macID1")
        self.label_16 = QtWidgets.QLabel(Form)
        self.label_16.setGeometry(QtCore.QRect(710, 90, 31, 39))
        self.label_16.setObjectName("label_16")
        self.label_17 = QtWidgets.QLabel(Form)
        self.label_17.setGeometry(QtCore.QRect(650, 90, 31, 39))
        self.label_17.setObjectName("label_17")
        self.label_18 = QtWidgets.QLabel(Form)
        self.label_18.setGeometry(QtCore.QRect(790, 90, 31, 39))
        self.label_18.setObjectName("label_18")
        self.label_number1 = QtWidgets.QLabel(Form)
        self.label_number1.setGeometry(QtCore.QRect(720, 150, 21, 21))
        self.label_number1.setObjectName("label_number1")
        self.label_unitPrice1 = QtWidgets.QLabel(Form)
        self.label_unitPrice1.setGeometry(QtCore.QRect(620, 140, 71, 41))
        self.label_unitPrice1.setObjectName("label_unitPrice1")
        self.label_amount1 = QtWidgets.QLabel(Form)
        self.label_amount1.setGeometry(QtCore.QRect(760, 140, 71, 41))
        self.label_amount1.setObjectName("label_amount1")
        self.label_19 = QtWidgets.QLabel(Form)
        self.label_19.setGeometry(QtCore.QRect(860, 90, 41, 39))
        self.label_19.setObjectName("label_19")
        self.label_paid1 = QtWidgets.QLabel(Form)
        self.label_paid1.setGeometry(QtCore.QRect(850, 150, 61, 21))
        self.label_paid1.setObjectName("label_paid1")
        self.label_20 = QtWidgets.QLabel(Form)
        self.label_20.setGeometry(QtCore.QRect(950, 90, 41, 39))
        self.label_20.setObjectName("label_20")
        self.label_receivable1 = QtWidgets.QLabel(Form)
        self.label_receivable1.setGeometry(QtCore.QRect(930, 150, 71, 21))
        self.label_receivable1.setObjectName("label_receivable1")
        self.label_payRemind1 = QtWidgets.QLabel(Form)
        self.label_payRemind1.setGeometry(QtCore.QRect(1020, 150, 81, 21))
        self.label_payRemind1.setObjectName("label_payRemind1")
        self.line_10 = QtWidgets.QFrame(Form)
        self.line_10.setGeometry(QtCore.QRect(130, 140, 20, 41))
        self.line_10.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_10.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_10.setObjectName("line_10")
        self.line_11 = QtWidgets.QFrame(Form)
        self.line_11.setGeometry(QtCore.QRect(40, 140, 20, 41))
        self.line_11.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_11.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_11.setObjectName("line_11")
        self.pushButton_search = QtWidgets.QPushButton(Form)
        self.pushButton_search.setGeometry(QtCore.QRect(160, 20, 41, 21))
        self.pushButton_search.setObjectName("pushButton_search")
        self.pushButton_SwitchShipment = QtWidgets.QPushButton(Form)
        self.pushButton_SwitchShipment.setGeometry(QtCore.QRect(830, 20, 81, 23))
        self.pushButton_SwitchShipment.setObjectName("pushButton_SwitchShipment")
        self.label_22 = QtWidgets.QLabel(Form)
        self.label_22.setGeometry(QtCore.QRect(440, 640, 141, 39))
        self.label_22.setObjectName("label_22")
        self.label_cPage = QtWidgets.QLabel(Form)
        self.label_cPage.setGeometry(QtCore.QRect(470, 650, 31, 21))
        self.label_cPage.setObjectName("label_cPage")
        self.label_tPage = QtWidgets.QLabel(Form)
        self.label_tPage.setGeometry(QtCore.QRect(510, 650, 41, 21))
        self.label_tPage.setObjectName("label_tPage")
        self.label_order1 = QtWidgets.QLabel(Form)
        self.label_order1.setGeometry(QtCore.QRect(10, 150, 31, 21))
        self.label_order1.setObjectName("label_order1")
        self.line_8 = QtWidgets.QFrame(Form)
        self.line_8.setGeometry(QtCore.QRect(50, 130, 1061, 20))
        self.line_8.setFrameShape(QtWidgets.QFrame.HLine)
        self.line_8.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_8.setObjectName("line_8")
        self.line_12 = QtWidgets.QFrame(Form)
        self.line_12.setGeometry(QtCore.QRect(50, 170, 1061, 20))
        self.line_12.setFrameShape(QtWidgets.QFrame.HLine)
        self.line_12.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_12.setObjectName("line_12")
        self.line_13 = QtWidgets.QFrame(Form)
        self.line_13.setGeometry(QtCore.QRect(340, 140, 20, 41))
        self.line_13.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_13.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_13.setObjectName("line_13")
        self.line_14 = QtWidgets.QFrame(Form)
        self.line_14.setGeometry(QtCore.QRect(450, 140, 20, 41))
        self.line_14.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_14.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_14.setObjectName("line_14")
        self.line_15 = QtWidgets.QFrame(Form)
        self.line_15.setGeometry(QtCore.QRect(530, 140, 20, 41))
        self.line_15.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_15.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_15.setObjectName("line_15")
        self.line_16 = QtWidgets.QFrame(Form)
        self.line_16.setGeometry(QtCore.QRect(600, 140, 20, 41))
        self.line_16.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_16.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_16.setObjectName("line_16")
        self.line_17 = QtWidgets.QFrame(Form)
        self.line_17.setGeometry(QtCore.QRect(690, 140, 20, 41))
        self.line_17.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_17.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_17.setObjectName("line_17")
        self.line_18 = QtWidgets.QFrame(Form)
        self.line_18.setGeometry(QtCore.QRect(740, 140, 20, 41))
        self.line_18.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_18.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_18.setObjectName("line_18")
        self.line_19 = QtWidgets.QFrame(Form)
        self.line_19.setGeometry(QtCore.QRect(830, 140, 20, 41))
        self.line_19.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_19.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_19.setObjectName("line_19")
        self.line_20 = QtWidgets.QFrame(Form)
        self.line_20.setGeometry(QtCore.QRect(910, 140, 20, 41))
        self.line_20.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_20.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_20.setObjectName("line_20")
        self.line_21 = QtWidgets.QFrame(Form)
        self.line_21.setGeometry(QtCore.QRect(1000, 140, 20, 41))
        self.line_21.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_21.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_21.setObjectName("line_21")
        self.line_22 = QtWidgets.QFrame(Form)
        self.line_22.setGeometry(QtCore.QRect(1100, 140, 20, 41))
        self.line_22.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_22.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_22.setObjectName("line_22")
        self.pushButton_edit1 = QtWidgets.QPushButton(Form)
        self.pushButton_edit1.setGeometry(QtCore.QRect(1130, 150, 71, 23))
        self.pushButton_edit1.setObjectName("pushButton_edit1")
        self.line_23 = QtWidgets.QFrame(Form)
        self.line_23.setGeometry(QtCore.QRect(450, 190, 20, 41))
        self.line_23.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_23.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_23.setObjectName("line_23")
        self.label_receivable2 = QtWidgets.QLabel(Form)
        self.label_receivable2.setGeometry(QtCore.QRect(930, 200, 71, 21))
        self.label_receivable2.setObjectName("label_receivable2")
        self.line_24 = QtWidgets.QFrame(Form)
        self.line_24.setGeometry(QtCore.QRect(830, 190, 20, 41))
        self.line_24.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_24.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_24.setObjectName("line_24")
        self.label_production2 = QtWidgets.QLabel(Form)
        self.label_production2.setGeometry(QtCore.QRect(360, 200, 91, 21))
        self.label_production2.setObjectName("label_production2")
        self.label_number2 = QtWidgets.QLabel(Form)
        self.label_number2.setGeometry(QtCore.QRect(720, 200, 21, 21))
        self.label_number2.setObjectName("label_number2")
        self.label_macID2 = QtWidgets.QLabel(Form)
        self.label_macID2.setGeometry(QtCore.QRect(550, 200, 51, 21))
        self.label_macID2.setObjectName("label_macID2")
        self.line_25 = QtWidgets.QFrame(Form)
        self.line_25.setGeometry(QtCore.QRect(600, 190, 20, 41))
        self.line_25.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_25.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_25.setObjectName("line_25")
        self.line_26 = QtWidgets.QFrame(Form)
        self.line_26.setGeometry(QtCore.QRect(1000, 190, 20, 41))
        self.line_26.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_26.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_26.setObjectName("line_26")
        self.pushButton_edit2 = QtWidgets.QPushButton(Form)
        self.pushButton_edit2.setGeometry(QtCore.QRect(1130, 200, 71, 23))
        self.pushButton_edit2.setObjectName("pushButton_edit2")
        self.label_paid2 = QtWidgets.QLabel(Form)
        self.label_paid2.setGeometry(QtCore.QRect(850, 200, 61, 21))
        self.label_paid2.setObjectName("label_paid2")
        self.line_27 = QtWidgets.QFrame(Form)
        self.line_27.setGeometry(QtCore.QRect(910, 190, 20, 41))
        self.line_27.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_27.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_27.setObjectName("line_27")
        self.line_28 = QtWidgets.QFrame(Form)
        self.line_28.setGeometry(QtCore.QRect(50, 180, 1061, 20))
        self.line_28.setFrameShape(QtWidgets.QFrame.HLine)
        self.line_28.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_28.setObjectName("line_28")
        self.line_29 = QtWidgets.QFrame(Form)
        self.line_29.setGeometry(QtCore.QRect(690, 190, 20, 41))
        self.line_29.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_29.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_29.setObjectName("line_29")
        self.line_30 = QtWidgets.QFrame(Form)
        self.line_30.setGeometry(QtCore.QRect(340, 190, 20, 41))
        self.line_30.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_30.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_30.setObjectName("line_30")
        self.line_31 = QtWidgets.QFrame(Form)
        self.line_31.setGeometry(QtCore.QRect(740, 190, 20, 41))
        self.line_31.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_31.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_31.setObjectName("line_31")
        self.line_32 = QtWidgets.QFrame(Form)
        self.line_32.setGeometry(QtCore.QRect(50, 220, 1061, 20))
        self.line_32.setFrameShape(QtWidgets.QFrame.HLine)
        self.line_32.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_32.setObjectName("line_32")
        self.label_shipDate2 = QtWidgets.QLabel(Form)
        self.label_shipDate2.setGeometry(QtCore.QRect(60, 200, 71, 21))
        self.label_shipDate2.setObjectName("label_shipDate2")
        self.label_customer2 = QtWidgets.QLabel(Form)
        self.label_customer2.setGeometry(QtCore.QRect(150, 190, 191, 41))
        self.label_customer2.setObjectName("label_customer2")
        self.line_33 = QtWidgets.QFrame(Form)
        self.line_33.setGeometry(QtCore.QRect(40, 190, 20, 41))
        self.line_33.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_33.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_33.setObjectName("line_33")
        self.line_34 = QtWidgets.QFrame(Form)
        self.line_34.setGeometry(QtCore.QRect(530, 190, 20, 41))
        self.line_34.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_34.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_34.setObjectName("line_34")
        self.label_payRemind2 = QtWidgets.QLabel(Form)
        self.label_payRemind2.setGeometry(QtCore.QRect(1020, 200, 81, 21))
        self.label_payRemind2.setObjectName("label_payRemind2")
        self.label_order2 = QtWidgets.QLabel(Form)
        self.label_order2.setGeometry(QtCore.QRect(10, 200, 31, 21))
        self.label_order2.setObjectName("label_order2")
        self.label_unitPrice2 = QtWidgets.QLabel(Form)
        self.label_unitPrice2.setGeometry(QtCore.QRect(620, 190, 71, 41))
        self.label_unitPrice2.setObjectName("label_unitPrice2")
        self.label_model2 = QtWidgets.QLabel(Form)
        self.label_model2.setGeometry(QtCore.QRect(470, 200, 61, 21))
        self.label_model2.setObjectName("label_model2")
        self.line_35 = QtWidgets.QFrame(Form)
        self.line_35.setGeometry(QtCore.QRect(1100, 190, 20, 41))
        self.line_35.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_35.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_35.setObjectName("line_35")
        self.line_36 = QtWidgets.QFrame(Form)
        self.line_36.setGeometry(QtCore.QRect(130, 190, 20, 41))
        self.line_36.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_36.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_36.setObjectName("line_36")
        self.label_amount2 = QtWidgets.QLabel(Form)
        self.label_amount2.setGeometry(QtCore.QRect(760, 190, 71, 41))
        self.label_amount2.setObjectName("label_amount2")
        self.line_37 = QtWidgets.QFrame(Form)
        self.line_37.setGeometry(QtCore.QRect(450, 240, 20, 41))
        self.line_37.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_37.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_37.setObjectName("line_37")
        self.label_receivable3 = QtWidgets.QLabel(Form)
        self.label_receivable3.setGeometry(QtCore.QRect(930, 250, 71, 21))
        self.label_receivable3.setObjectName("label_receivable3")
        self.line_38 = QtWidgets.QFrame(Form)
        self.line_38.setGeometry(QtCore.QRect(830, 240, 20, 41))
        self.line_38.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_38.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_38.setObjectName("line_38")
        self.label_production3 = QtWidgets.QLabel(Form)
        self.label_production3.setGeometry(QtCore.QRect(360, 250, 91, 21))
        self.label_production3.setObjectName("label_production3")
        self.label_number3 = QtWidgets.QLabel(Form)
        self.label_number3.setGeometry(QtCore.QRect(720, 250, 21, 21))
        self.label_number3.setObjectName("label_number3")
        self.label_macID3 = QtWidgets.QLabel(Form)
        self.label_macID3.setGeometry(QtCore.QRect(550, 250, 51, 21))
        self.label_macID3.setObjectName("label_macID3")
        self.line_39 = QtWidgets.QFrame(Form)
        self.line_39.setGeometry(QtCore.QRect(600, 240, 20, 41))
        self.line_39.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_39.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_39.setObjectName("line_39")
        self.line_40 = QtWidgets.QFrame(Form)
        self.line_40.setGeometry(QtCore.QRect(1000, 240, 20, 41))
        self.line_40.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_40.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_40.setObjectName("line_40")
        self.pushButton_edit3 = QtWidgets.QPushButton(Form)
        self.pushButton_edit3.setGeometry(QtCore.QRect(1130, 250, 71, 23))
        self.pushButton_edit3.setObjectName("pushButton_edit3")
        self.label_paid3 = QtWidgets.QLabel(Form)
        self.label_paid3.setGeometry(QtCore.QRect(850, 250, 61, 21))
        self.label_paid3.setObjectName("label_paid3")
        self.line_41 = QtWidgets.QFrame(Form)
        self.line_41.setGeometry(QtCore.QRect(910, 240, 20, 41))
        self.line_41.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_41.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_41.setObjectName("line_41")
        self.line_42 = QtWidgets.QFrame(Form)
        self.line_42.setGeometry(QtCore.QRect(50, 230, 1061, 20))
        self.line_42.setFrameShape(QtWidgets.QFrame.HLine)
        self.line_42.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_42.setObjectName("line_42")
        self.line_43 = QtWidgets.QFrame(Form)
        self.line_43.setGeometry(QtCore.QRect(690, 240, 20, 41))
        self.line_43.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_43.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_43.setObjectName("line_43")
        self.line_44 = QtWidgets.QFrame(Form)
        self.line_44.setGeometry(QtCore.QRect(340, 240, 20, 41))
        self.line_44.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_44.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_44.setObjectName("line_44")
        self.line_45 = QtWidgets.QFrame(Form)
        self.line_45.setGeometry(QtCore.QRect(740, 240, 20, 41))
        self.line_45.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_45.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_45.setObjectName("line_45")
        self.line_46 = QtWidgets.QFrame(Form)
        self.line_46.setGeometry(QtCore.QRect(50, 270, 1061, 20))
        self.line_46.setFrameShape(QtWidgets.QFrame.HLine)
        self.line_46.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_46.setObjectName("line_46")
        self.label_shipDate3 = QtWidgets.QLabel(Form)
        self.label_shipDate3.setGeometry(QtCore.QRect(60, 250, 71, 21))
        self.label_shipDate3.setObjectName("label_shipDate3")
        self.label_customer3 = QtWidgets.QLabel(Form)
        self.label_customer3.setGeometry(QtCore.QRect(150, 240, 191, 41))
        self.label_customer3.setObjectName("label_customer3")
        self.line_47 = QtWidgets.QFrame(Form)
        self.line_47.setGeometry(QtCore.QRect(40, 240, 20, 41))
        self.line_47.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_47.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_47.setObjectName("line_47")
        self.line_48 = QtWidgets.QFrame(Form)
        self.line_48.setGeometry(QtCore.QRect(530, 240, 20, 41))
        self.line_48.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_48.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_48.setObjectName("line_48")
        self.label_payRemind3 = QtWidgets.QLabel(Form)
        self.label_payRemind3.setGeometry(QtCore.QRect(1020, 250, 81, 21))
        self.label_payRemind3.setObjectName("label_payRemind3")
        self.label_order3 = QtWidgets.QLabel(Form)
        self.label_order3.setGeometry(QtCore.QRect(10, 250, 31, 21))
        self.label_order3.setObjectName("label_order3")
        self.label_unitPrice3 = QtWidgets.QLabel(Form)
        self.label_unitPrice3.setGeometry(QtCore.QRect(620, 240, 71, 41))
        self.label_unitPrice3.setObjectName("label_unitPrice3")
        self.label_model3 = QtWidgets.QLabel(Form)
        self.label_model3.setGeometry(QtCore.QRect(470, 250, 61, 21))
        self.label_model3.setObjectName("label_model3")
        self.line_49 = QtWidgets.QFrame(Form)
        self.line_49.setGeometry(QtCore.QRect(1100, 240, 20, 41))
        self.line_49.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_49.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_49.setObjectName("line_49")
        self.line_50 = QtWidgets.QFrame(Form)
        self.line_50.setGeometry(QtCore.QRect(130, 240, 20, 41))
        self.line_50.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_50.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_50.setObjectName("line_50")
        self.label_amount3 = QtWidgets.QLabel(Form)
        self.label_amount3.setGeometry(QtCore.QRect(760, 240, 71, 41))
        self.label_amount3.setObjectName("label_amount3")
        self.line_51 = QtWidgets.QFrame(Form)
        self.line_51.setGeometry(QtCore.QRect(450, 290, 20, 41))
        self.line_51.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_51.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_51.setObjectName("line_51")
        self.label_receivable4 = QtWidgets.QLabel(Form)
        self.label_receivable4.setGeometry(QtCore.QRect(930, 300, 71, 21))
        self.label_receivable4.setObjectName("label_receivable4")
        self.line_52 = QtWidgets.QFrame(Form)
        self.line_52.setGeometry(QtCore.QRect(830, 290, 20, 41))
        self.line_52.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_52.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_52.setObjectName("line_52")
        self.label_production4 = QtWidgets.QLabel(Form)
        self.label_production4.setGeometry(QtCore.QRect(360, 300, 91, 21))
        self.label_production4.setObjectName("label_production4")
        self.label_number4 = QtWidgets.QLabel(Form)
        self.label_number4.setGeometry(QtCore.QRect(720, 300, 21, 21))
        self.label_number4.setObjectName("label_number4")
        self.label_macID4 = QtWidgets.QLabel(Form)
        self.label_macID4.setGeometry(QtCore.QRect(550, 300, 51, 21))
        self.label_macID4.setObjectName("label_macID4")
        self.line_53 = QtWidgets.QFrame(Form)
        self.line_53.setGeometry(QtCore.QRect(600, 290, 20, 41))
        self.line_53.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_53.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_53.setObjectName("line_53")
        self.line_54 = QtWidgets.QFrame(Form)
        self.line_54.setGeometry(QtCore.QRect(1000, 290, 20, 41))
        self.line_54.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_54.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_54.setObjectName("line_54")
        self.pushButton_edit4 = QtWidgets.QPushButton(Form)
        self.pushButton_edit4.setGeometry(QtCore.QRect(1130, 300, 71, 23))
        self.pushButton_edit4.setObjectName("pushButton_edit4")
        self.label_paid4 = QtWidgets.QLabel(Form)
        self.label_paid4.setGeometry(QtCore.QRect(850, 300, 61, 21))
        self.label_paid4.setObjectName("label_paid4")
        self.line_55 = QtWidgets.QFrame(Form)
        self.line_55.setGeometry(QtCore.QRect(910, 290, 20, 41))
        self.line_55.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_55.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_55.setObjectName("line_55")
        self.line_56 = QtWidgets.QFrame(Form)
        self.line_56.setGeometry(QtCore.QRect(50, 280, 1061, 20))
        self.line_56.setFrameShape(QtWidgets.QFrame.HLine)
        self.line_56.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_56.setObjectName("line_56")
        self.line_57 = QtWidgets.QFrame(Form)
        self.line_57.setGeometry(QtCore.QRect(690, 290, 20, 41))
        self.line_57.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_57.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_57.setObjectName("line_57")
        self.line_58 = QtWidgets.QFrame(Form)
        self.line_58.setGeometry(QtCore.QRect(340, 290, 20, 41))
        self.line_58.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_58.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_58.setObjectName("line_58")
        self.line_59 = QtWidgets.QFrame(Form)
        self.line_59.setGeometry(QtCore.QRect(740, 290, 20, 41))
        self.line_59.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_59.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_59.setObjectName("line_59")
        self.line_60 = QtWidgets.QFrame(Form)
        self.line_60.setGeometry(QtCore.QRect(50, 320, 1061, 20))
        self.line_60.setFrameShape(QtWidgets.QFrame.HLine)
        self.line_60.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_60.setObjectName("line_60")
        self.label_shipDate4 = QtWidgets.QLabel(Form)
        self.label_shipDate4.setGeometry(QtCore.QRect(60, 300, 71, 21))
        self.label_shipDate4.setObjectName("label_shipDate4")
        self.label_customer4 = QtWidgets.QLabel(Form)
        self.label_customer4.setGeometry(QtCore.QRect(150, 290, 191, 41))
        self.label_customer4.setObjectName("label_customer4")
        self.line_61 = QtWidgets.QFrame(Form)
        self.line_61.setGeometry(QtCore.QRect(40, 290, 20, 41))
        self.line_61.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_61.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_61.setObjectName("line_61")
        self.line_62 = QtWidgets.QFrame(Form)
        self.line_62.setGeometry(QtCore.QRect(530, 290, 20, 41))
        self.line_62.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_62.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_62.setObjectName("line_62")
        self.label_payRemind4 = QtWidgets.QLabel(Form)
        self.label_payRemind4.setGeometry(QtCore.QRect(1020, 300, 81, 21))
        self.label_payRemind4.setObjectName("label_payRemind4")
        self.label_order4 = QtWidgets.QLabel(Form)
        self.label_order4.setGeometry(QtCore.QRect(10, 300, 31, 21))
        self.label_order4.setObjectName("label_order4")
        self.label_unitPrice4 = QtWidgets.QLabel(Form)
        self.label_unitPrice4.setGeometry(QtCore.QRect(620, 290, 71, 41))
        self.label_unitPrice4.setObjectName("label_unitPrice4")
        self.label_model4 = QtWidgets.QLabel(Form)
        self.label_model4.setGeometry(QtCore.QRect(470, 300, 61, 21))
        self.label_model4.setObjectName("label_model4")
        self.line_63 = QtWidgets.QFrame(Form)
        self.line_63.setGeometry(QtCore.QRect(1100, 290, 20, 41))
        self.line_63.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_63.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_63.setObjectName("line_63")
        self.line_64 = QtWidgets.QFrame(Form)
        self.line_64.setGeometry(QtCore.QRect(130, 290, 20, 41))
        self.line_64.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_64.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_64.setObjectName("line_64")
        self.label_amount4 = QtWidgets.QLabel(Form)
        self.label_amount4.setGeometry(QtCore.QRect(760, 290, 71, 41))
        self.label_amount4.setObjectName("label_amount4")
        self.line_65 = QtWidgets.QFrame(Form)
        self.line_65.setGeometry(QtCore.QRect(450, 340, 20, 41))
        self.line_65.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_65.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_65.setObjectName("line_65")
        self.label_receivable5 = QtWidgets.QLabel(Form)
        self.label_receivable5.setGeometry(QtCore.QRect(930, 350, 71, 21))
        self.label_receivable5.setObjectName("label_receivable5")
        self.line_66 = QtWidgets.QFrame(Form)
        self.line_66.setGeometry(QtCore.QRect(830, 340, 20, 41))
        self.line_66.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_66.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_66.setObjectName("line_66")
        self.label_production5 = QtWidgets.QLabel(Form)
        self.label_production5.setGeometry(QtCore.QRect(360, 350, 91, 21))
        self.label_production5.setObjectName("label_production5")
        self.label_number5 = QtWidgets.QLabel(Form)
        self.label_number5.setGeometry(QtCore.QRect(720, 350, 21, 21))
        self.label_number5.setObjectName("label_number5")
        self.label_macID5 = QtWidgets.QLabel(Form)
        self.label_macID5.setGeometry(QtCore.QRect(550, 350, 51, 21))
        self.label_macID5.setObjectName("label_macID5")
        self.line_67 = QtWidgets.QFrame(Form)
        self.line_67.setGeometry(QtCore.QRect(600, 340, 20, 41))
        self.line_67.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_67.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_67.setObjectName("line_67")
        self.line_68 = QtWidgets.QFrame(Form)
        self.line_68.setGeometry(QtCore.QRect(1000, 340, 20, 41))
        self.line_68.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_68.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_68.setObjectName("line_68")
        self.pushButton_edit5 = QtWidgets.QPushButton(Form)
        self.pushButton_edit5.setGeometry(QtCore.QRect(1130, 350, 71, 23))
        self.pushButton_edit5.setObjectName("pushButton_edit5")
        self.label_paid5 = QtWidgets.QLabel(Form)
        self.label_paid5.setGeometry(QtCore.QRect(850, 350, 61, 21))
        self.label_paid5.setObjectName("label_paid5")
        self.line_69 = QtWidgets.QFrame(Form)
        self.line_69.setGeometry(QtCore.QRect(910, 340, 20, 41))
        self.line_69.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_69.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_69.setObjectName("line_69")
        self.line_70 = QtWidgets.QFrame(Form)
        self.line_70.setGeometry(QtCore.QRect(50, 330, 1061, 20))
        self.line_70.setFrameShape(QtWidgets.QFrame.HLine)
        self.line_70.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_70.setObjectName("line_70")
        self.line_71 = QtWidgets.QFrame(Form)
        self.line_71.setGeometry(QtCore.QRect(690, 340, 20, 41))
        self.line_71.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_71.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_71.setObjectName("line_71")
        self.line_72 = QtWidgets.QFrame(Form)
        self.line_72.setGeometry(QtCore.QRect(340, 340, 20, 41))
        self.line_72.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_72.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_72.setObjectName("line_72")
        self.line_73 = QtWidgets.QFrame(Form)
        self.line_73.setGeometry(QtCore.QRect(740, 340, 20, 41))
        self.line_73.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_73.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_73.setObjectName("line_73")
        self.line_74 = QtWidgets.QFrame(Form)
        self.line_74.setGeometry(QtCore.QRect(50, 370, 1061, 20))
        self.line_74.setFrameShape(QtWidgets.QFrame.HLine)
        self.line_74.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_74.setObjectName("line_74")
        self.label_shipDate5 = QtWidgets.QLabel(Form)
        self.label_shipDate5.setGeometry(QtCore.QRect(60, 350, 71, 21))
        self.label_shipDate5.setObjectName("label_shipDate5")
        self.label_customer5 = QtWidgets.QLabel(Form)
        self.label_customer5.setGeometry(QtCore.QRect(150, 340, 191, 41))
        self.label_customer5.setObjectName("label_customer5")
        self.line_75 = QtWidgets.QFrame(Form)
        self.line_75.setGeometry(QtCore.QRect(40, 340, 20, 41))
        self.line_75.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_75.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_75.setObjectName("line_75")
        self.line_76 = QtWidgets.QFrame(Form)
        self.line_76.setGeometry(QtCore.QRect(530, 340, 20, 41))
        self.line_76.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_76.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_76.setObjectName("line_76")
        self.label_payRemind5 = QtWidgets.QLabel(Form)
        self.label_payRemind5.setGeometry(QtCore.QRect(1020, 350, 81, 21))
        self.label_payRemind5.setObjectName("label_payRemind5")
        self.label_order5 = QtWidgets.QLabel(Form)
        self.label_order5.setGeometry(QtCore.QRect(10, 350, 31, 21))
        self.label_order5.setObjectName("label_order5")
        self.label_unitPrice5 = QtWidgets.QLabel(Form)
        self.label_unitPrice5.setGeometry(QtCore.QRect(620, 340, 71, 41))
        self.label_unitPrice5.setObjectName("label_unitPrice5")
        self.label_model5 = QtWidgets.QLabel(Form)
        self.label_model5.setGeometry(QtCore.QRect(470, 350, 61, 21))
        self.label_model5.setObjectName("label_model5")
        self.line_77 = QtWidgets.QFrame(Form)
        self.line_77.setGeometry(QtCore.QRect(1100, 340, 20, 41))
        self.line_77.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_77.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_77.setObjectName("line_77")
        self.line_78 = QtWidgets.QFrame(Form)
        self.line_78.setGeometry(QtCore.QRect(130, 340, 20, 41))
        self.line_78.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_78.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_78.setObjectName("line_78")
        self.label_amount5 = QtWidgets.QLabel(Form)
        self.label_amount5.setGeometry(QtCore.QRect(760, 340, 71, 41))
        self.label_amount5.setObjectName("label_amount5")
        self.line_79 = QtWidgets.QFrame(Form)
        self.line_79.setGeometry(QtCore.QRect(450, 390, 20, 41))
        self.line_79.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_79.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_79.setObjectName("line_79")
        self.label_receivable6 = QtWidgets.QLabel(Form)
        self.label_receivable6.setGeometry(QtCore.QRect(930, 400, 71, 21))
        self.label_receivable6.setObjectName("label_receivable6")
        self.line_80 = QtWidgets.QFrame(Form)
        self.line_80.setGeometry(QtCore.QRect(830, 390, 20, 41))
        self.line_80.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_80.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_80.setObjectName("line_80")
        self.label_production6 = QtWidgets.QLabel(Form)
        self.label_production6.setGeometry(QtCore.QRect(360, 400, 91, 21))
        self.label_production6.setObjectName("label_production6")
        self.label_number6 = QtWidgets.QLabel(Form)
        self.label_number6.setGeometry(QtCore.QRect(720, 400, 21, 21))
        self.label_number6.setObjectName("label_number6")
        self.label_macID6 = QtWidgets.QLabel(Form)
        self.label_macID6.setGeometry(QtCore.QRect(550, 400, 51, 21))
        self.label_macID6.setObjectName("label_macID6")
        self.line_81 = QtWidgets.QFrame(Form)
        self.line_81.setGeometry(QtCore.QRect(600, 390, 20, 41))
        self.line_81.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_81.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_81.setObjectName("line_81")
        self.line_82 = QtWidgets.QFrame(Form)
        self.line_82.setGeometry(QtCore.QRect(1000, 390, 20, 41))
        self.line_82.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_82.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_82.setObjectName("line_82")
        self.pushButton_edit6 = QtWidgets.QPushButton(Form)
        self.pushButton_edit6.setGeometry(QtCore.QRect(1130, 400, 71, 23))
        self.pushButton_edit6.setObjectName("pushButton_edit6")
        self.label_paid6 = QtWidgets.QLabel(Form)
        self.label_paid6.setGeometry(QtCore.QRect(850, 400, 61, 21))
        self.label_paid6.setObjectName("label_paid6")
        self.line_83 = QtWidgets.QFrame(Form)
        self.line_83.setGeometry(QtCore.QRect(910, 390, 20, 41))
        self.line_83.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_83.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_83.setObjectName("line_83")
        self.line_84 = QtWidgets.QFrame(Form)
        self.line_84.setGeometry(QtCore.QRect(50, 380, 1061, 20))
        self.line_84.setFrameShape(QtWidgets.QFrame.HLine)
        self.line_84.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_84.setObjectName("line_84")
        self.line_85 = QtWidgets.QFrame(Form)
        self.line_85.setGeometry(QtCore.QRect(690, 390, 20, 41))
        self.line_85.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_85.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_85.setObjectName("line_85")
        self.line_86 = QtWidgets.QFrame(Form)
        self.line_86.setGeometry(QtCore.QRect(340, 390, 20, 41))
        self.line_86.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_86.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_86.setObjectName("line_86")
        self.line_87 = QtWidgets.QFrame(Form)
        self.line_87.setGeometry(QtCore.QRect(740, 390, 20, 41))
        self.line_87.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_87.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_87.setObjectName("line_87")
        self.line_88 = QtWidgets.QFrame(Form)
        self.line_88.setGeometry(QtCore.QRect(50, 420, 1061, 20))
        self.line_88.setFrameShape(QtWidgets.QFrame.HLine)
        self.line_88.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_88.setObjectName("line_88")
        self.label_shipDate6 = QtWidgets.QLabel(Form)
        self.label_shipDate6.setGeometry(QtCore.QRect(60, 400, 71, 21))
        self.label_shipDate6.setObjectName("label_shipDate6")
        self.label_customer6 = QtWidgets.QLabel(Form)
        self.label_customer6.setGeometry(QtCore.QRect(150, 390, 191, 41))
        self.label_customer6.setObjectName("label_customer6")
        self.line_89 = QtWidgets.QFrame(Form)
        self.line_89.setGeometry(QtCore.QRect(40, 390, 20, 41))
        self.line_89.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_89.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_89.setObjectName("line_89")
        self.line_90 = QtWidgets.QFrame(Form)
        self.line_90.setGeometry(QtCore.QRect(530, 390, 20, 41))
        self.line_90.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_90.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_90.setObjectName("line_90")
        self.label_payRemind6 = QtWidgets.QLabel(Form)
        self.label_payRemind6.setGeometry(QtCore.QRect(1020, 400, 81, 21))
        self.label_payRemind6.setObjectName("label_payRemind6")
        self.label_order6 = QtWidgets.QLabel(Form)
        self.label_order6.setGeometry(QtCore.QRect(10, 400, 31, 21))
        self.label_order6.setObjectName("label_order6")
        self.label_unitPrice6 = QtWidgets.QLabel(Form)
        self.label_unitPrice6.setGeometry(QtCore.QRect(620, 390, 71, 41))
        self.label_unitPrice6.setObjectName("label_unitPrice6")
        self.label_model6 = QtWidgets.QLabel(Form)
        self.label_model6.setGeometry(QtCore.QRect(470, 400, 61, 21))
        self.label_model6.setObjectName("label_model6")
        self.line_91 = QtWidgets.QFrame(Form)
        self.line_91.setGeometry(QtCore.QRect(1100, 390, 20, 41))
        self.line_91.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_91.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_91.setObjectName("line_91")
        self.line_92 = QtWidgets.QFrame(Form)
        self.line_92.setGeometry(QtCore.QRect(130, 390, 20, 41))
        self.line_92.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_92.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_92.setObjectName("line_92")
        self.label_amount6 = QtWidgets.QLabel(Form)
        self.label_amount6.setGeometry(QtCore.QRect(760, 390, 71, 41))
        self.label_amount6.setObjectName("label_amount6")
        self.line_93 = QtWidgets.QFrame(Form)
        self.line_93.setGeometry(QtCore.QRect(450, 440, 20, 41))
        self.line_93.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_93.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_93.setObjectName("line_93")
        self.label_receivable7 = QtWidgets.QLabel(Form)
        self.label_receivable7.setGeometry(QtCore.QRect(930, 450, 71, 21))
        self.label_receivable7.setObjectName("label_receivable7")
        self.line_94 = QtWidgets.QFrame(Form)
        self.line_94.setGeometry(QtCore.QRect(830, 440, 20, 41))
        self.line_94.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_94.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_94.setObjectName("line_94")
        self.label_production7 = QtWidgets.QLabel(Form)
        self.label_production7.setGeometry(QtCore.QRect(360, 450, 91, 21))
        self.label_production7.setObjectName("label_production7")
        self.label_number7 = QtWidgets.QLabel(Form)
        self.label_number7.setGeometry(QtCore.QRect(720, 450, 21, 21))
        self.label_number7.setObjectName("label_number7")
        self.label_macID7 = QtWidgets.QLabel(Form)
        self.label_macID7.setGeometry(QtCore.QRect(550, 450, 51, 21))
        self.label_macID7.setObjectName("label_macID7")
        self.line_95 = QtWidgets.QFrame(Form)
        self.line_95.setGeometry(QtCore.QRect(600, 440, 20, 41))
        self.line_95.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_95.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_95.setObjectName("line_95")
        self.line_96 = QtWidgets.QFrame(Form)
        self.line_96.setGeometry(QtCore.QRect(1000, 440, 20, 41))
        self.line_96.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_96.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_96.setObjectName("line_96")
        self.pushButton_edit7 = QtWidgets.QPushButton(Form)
        self.pushButton_edit7.setGeometry(QtCore.QRect(1130, 450, 71, 23))
        self.pushButton_edit7.setObjectName("pushButton_edit7")
        self.label_paid7 = QtWidgets.QLabel(Form)
        self.label_paid7.setGeometry(QtCore.QRect(850, 450, 61, 21))
        self.label_paid7.setObjectName("label_paid7")
        self.line_97 = QtWidgets.QFrame(Form)
        self.line_97.setGeometry(QtCore.QRect(910, 440, 20, 41))
        self.line_97.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_97.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_97.setObjectName("line_97")
        self.line_98 = QtWidgets.QFrame(Form)
        self.line_98.setGeometry(QtCore.QRect(50, 430, 1061, 20))
        self.line_98.setFrameShape(QtWidgets.QFrame.HLine)
        self.line_98.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_98.setObjectName("line_98")
        self.line_99 = QtWidgets.QFrame(Form)
        self.line_99.setGeometry(QtCore.QRect(690, 440, 20, 41))
        self.line_99.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_99.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_99.setObjectName("line_99")
        self.line_100 = QtWidgets.QFrame(Form)
        self.line_100.setGeometry(QtCore.QRect(340, 440, 20, 41))
        self.line_100.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_100.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_100.setObjectName("line_100")
        self.line_101 = QtWidgets.QFrame(Form)
        self.line_101.setGeometry(QtCore.QRect(740, 440, 20, 41))
        self.line_101.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_101.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_101.setObjectName("line_101")
        self.line_102 = QtWidgets.QFrame(Form)
        self.line_102.setGeometry(QtCore.QRect(50, 470, 1061, 20))
        self.line_102.setFrameShape(QtWidgets.QFrame.HLine)
        self.line_102.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_102.setObjectName("line_102")
        self.label_shipDate7 = QtWidgets.QLabel(Form)
        self.label_shipDate7.setGeometry(QtCore.QRect(60, 450, 71, 21))
        self.label_shipDate7.setObjectName("label_shipDate7")
        self.label_customer7 = QtWidgets.QLabel(Form)
        self.label_customer7.setGeometry(QtCore.QRect(150, 440, 191, 41))
        self.label_customer7.setObjectName("label_customer7")
        self.line_103 = QtWidgets.QFrame(Form)
        self.line_103.setGeometry(QtCore.QRect(40, 440, 20, 41))
        self.line_103.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_103.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_103.setObjectName("line_103")
        self.line_104 = QtWidgets.QFrame(Form)
        self.line_104.setGeometry(QtCore.QRect(530, 440, 20, 41))
        self.line_104.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_104.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_104.setObjectName("line_104")
        self.label_payRemind7 = QtWidgets.QLabel(Form)
        self.label_payRemind7.setGeometry(QtCore.QRect(1020, 450, 81, 21))
        self.label_payRemind7.setObjectName("label_payRemind7")
        self.label_order7 = QtWidgets.QLabel(Form)
        self.label_order7.setGeometry(QtCore.QRect(10, 450, 31, 21))
        self.label_order7.setObjectName("label_order7")
        self.label_unitPrice7 = QtWidgets.QLabel(Form)
        self.label_unitPrice7.setGeometry(QtCore.QRect(620, 440, 71, 41))
        self.label_unitPrice7.setObjectName("label_unitPrice7")
        self.label_model7 = QtWidgets.QLabel(Form)
        self.label_model7.setGeometry(QtCore.QRect(470, 450, 61, 21))
        self.label_model7.setObjectName("label_model7")
        self.line_105 = QtWidgets.QFrame(Form)
        self.line_105.setGeometry(QtCore.QRect(1100, 440, 20, 41))
        self.line_105.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_105.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_105.setObjectName("line_105")
        self.line_106 = QtWidgets.QFrame(Form)
        self.line_106.setGeometry(QtCore.QRect(130, 440, 20, 41))
        self.line_106.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_106.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_106.setObjectName("line_106")
        self.label_amount7 = QtWidgets.QLabel(Form)
        self.label_amount7.setGeometry(QtCore.QRect(760, 440, 71, 41))
        self.label_amount7.setObjectName("label_amount7")
        self.line_107 = QtWidgets.QFrame(Form)
        self.line_107.setGeometry(QtCore.QRect(450, 490, 20, 41))
        self.line_107.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_107.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_107.setObjectName("line_107")
        self.label_receivable8 = QtWidgets.QLabel(Form)
        self.label_receivable8.setGeometry(QtCore.QRect(930, 500, 71, 21))
        self.label_receivable8.setObjectName("label_receivable8")
        self.line_108 = QtWidgets.QFrame(Form)
        self.line_108.setGeometry(QtCore.QRect(830, 490, 20, 41))
        self.line_108.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_108.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_108.setObjectName("line_108")
        self.label_production8 = QtWidgets.QLabel(Form)
        self.label_production8.setGeometry(QtCore.QRect(360, 500, 91, 21))
        self.label_production8.setObjectName("label_production8")
        self.label_number8 = QtWidgets.QLabel(Form)
        self.label_number8.setGeometry(QtCore.QRect(720, 500, 21, 21))
        self.label_number8.setObjectName("label_number8")
        self.label_macID8 = QtWidgets.QLabel(Form)
        self.label_macID8.setGeometry(QtCore.QRect(550, 500, 51, 21))
        self.label_macID8.setObjectName("label_macID8")
        self.line_109 = QtWidgets.QFrame(Form)
        self.line_109.setGeometry(QtCore.QRect(600, 490, 20, 41))
        self.line_109.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_109.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_109.setObjectName("line_109")
        self.line_110 = QtWidgets.QFrame(Form)
        self.line_110.setGeometry(QtCore.QRect(1000, 490, 20, 41))
        self.line_110.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_110.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_110.setObjectName("line_110")
        self.pushButton_edit8 = QtWidgets.QPushButton(Form)
        self.pushButton_edit8.setGeometry(QtCore.QRect(1130, 500, 71, 23))
        self.pushButton_edit8.setObjectName("pushButton_edit8")
        self.label_paid8 = QtWidgets.QLabel(Form)
        self.label_paid8.setGeometry(QtCore.QRect(850, 500, 61, 21))
        self.label_paid8.setObjectName("label_paid8")
        self.line_111 = QtWidgets.QFrame(Form)
        self.line_111.setGeometry(QtCore.QRect(910, 490, 20, 41))
        self.line_111.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_111.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_111.setObjectName("line_111")
        self.line_112 = QtWidgets.QFrame(Form)
        self.line_112.setGeometry(QtCore.QRect(50, 480, 1061, 20))
        self.line_112.setFrameShape(QtWidgets.QFrame.HLine)
        self.line_112.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_112.setObjectName("line_112")
        self.line_113 = QtWidgets.QFrame(Form)
        self.line_113.setGeometry(QtCore.QRect(690, 490, 20, 41))
        self.line_113.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_113.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_113.setObjectName("line_113")
        self.line_114 = QtWidgets.QFrame(Form)
        self.line_114.setGeometry(QtCore.QRect(340, 490, 20, 41))
        self.line_114.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_114.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_114.setObjectName("line_114")
        self.line_115 = QtWidgets.QFrame(Form)
        self.line_115.setGeometry(QtCore.QRect(740, 490, 20, 41))
        self.line_115.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_115.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_115.setObjectName("line_115")
        self.line_116 = QtWidgets.QFrame(Form)
        self.line_116.setGeometry(QtCore.QRect(50, 520, 1061, 20))
        self.line_116.setFrameShape(QtWidgets.QFrame.HLine)
        self.line_116.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_116.setObjectName("line_116")
        self.label_shipDate8 = QtWidgets.QLabel(Form)
        self.label_shipDate8.setGeometry(QtCore.QRect(60, 500, 71, 21))
        self.label_shipDate8.setObjectName("label_shipDate8")
        self.label_customer8 = QtWidgets.QLabel(Form)
        self.label_customer8.setGeometry(QtCore.QRect(150, 490, 191, 41))
        self.label_customer8.setObjectName("label_customer8")
        self.line_117 = QtWidgets.QFrame(Form)
        self.line_117.setGeometry(QtCore.QRect(40, 490, 20, 41))
        self.line_117.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_117.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_117.setObjectName("line_117")
        self.line_118 = QtWidgets.QFrame(Form)
        self.line_118.setGeometry(QtCore.QRect(530, 490, 20, 41))
        self.line_118.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_118.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_118.setObjectName("line_118")
        self.label_payRemind8 = QtWidgets.QLabel(Form)
        self.label_payRemind8.setGeometry(QtCore.QRect(1020, 500, 81, 21))
        self.label_payRemind8.setObjectName("label_payRemind8")
        self.label_order8 = QtWidgets.QLabel(Form)
        self.label_order8.setGeometry(QtCore.QRect(10, 500, 31, 21))
        self.label_order8.setObjectName("label_order8")
        self.label_unitPrice8 = QtWidgets.QLabel(Form)
        self.label_unitPrice8.setGeometry(QtCore.QRect(620, 490, 71, 41))
        self.label_unitPrice8.setObjectName("label_unitPrice8")
        self.label_model8 = QtWidgets.QLabel(Form)
        self.label_model8.setGeometry(QtCore.QRect(470, 500, 61, 21))
        self.label_model8.setObjectName("label_model8")
        self.line_119 = QtWidgets.QFrame(Form)
        self.line_119.setGeometry(QtCore.QRect(1100, 490, 20, 41))
        self.line_119.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_119.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_119.setObjectName("line_119")
        self.line_120 = QtWidgets.QFrame(Form)
        self.line_120.setGeometry(QtCore.QRect(130, 490, 20, 41))
        self.line_120.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_120.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_120.setObjectName("line_120")
        self.label_amount8 = QtWidgets.QLabel(Form)
        self.label_amount8.setGeometry(QtCore.QRect(760, 490, 71, 41))
        self.label_amount8.setObjectName("label_amount8")
        self.line_121 = QtWidgets.QFrame(Form)
        self.line_121.setGeometry(QtCore.QRect(450, 540, 20, 41))
        self.line_121.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_121.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_121.setObjectName("line_121")
        self.label_receivable9 = QtWidgets.QLabel(Form)
        self.label_receivable9.setGeometry(QtCore.QRect(930, 550, 71, 21))
        self.label_receivable9.setObjectName("label_receivable9")
        self.line_122 = QtWidgets.QFrame(Form)
        self.line_122.setGeometry(QtCore.QRect(830, 540, 20, 41))
        self.line_122.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_122.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_122.setObjectName("line_122")
        self.label_production9 = QtWidgets.QLabel(Form)
        self.label_production9.setGeometry(QtCore.QRect(360, 550, 91, 21))
        self.label_production9.setObjectName("label_production9")
        self.label_number9 = QtWidgets.QLabel(Form)
        self.label_number9.setGeometry(QtCore.QRect(720, 550, 21, 21))
        self.label_number9.setObjectName("label_number9")
        self.label_macID9 = QtWidgets.QLabel(Form)
        self.label_macID9.setGeometry(QtCore.QRect(550, 550, 51, 21))
        self.label_macID9.setObjectName("label_macID9")
        self.line_123 = QtWidgets.QFrame(Form)
        self.line_123.setGeometry(QtCore.QRect(600, 540, 20, 41))
        self.line_123.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_123.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_123.setObjectName("line_123")
        self.line_124 = QtWidgets.QFrame(Form)
        self.line_124.setGeometry(QtCore.QRect(1000, 540, 20, 41))
        self.line_124.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_124.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_124.setObjectName("line_124")
        self.pushButton_edit9 = QtWidgets.QPushButton(Form)
        self.pushButton_edit9.setGeometry(QtCore.QRect(1130, 550, 71, 23))
        self.pushButton_edit9.setObjectName("pushButton_edit9")
        self.label_paid9 = QtWidgets.QLabel(Form)
        self.label_paid9.setGeometry(QtCore.QRect(850, 550, 61, 21))
        self.label_paid9.setObjectName("label_paid9")
        self.line_125 = QtWidgets.QFrame(Form)
        self.line_125.setGeometry(QtCore.QRect(910, 540, 20, 41))
        self.line_125.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_125.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_125.setObjectName("line_125")
        self.line_126 = QtWidgets.QFrame(Form)
        self.line_126.setGeometry(QtCore.QRect(50, 530, 1061, 20))
        self.line_126.setFrameShape(QtWidgets.QFrame.HLine)
        self.line_126.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_126.setObjectName("line_126")
        self.line_127 = QtWidgets.QFrame(Form)
        self.line_127.setGeometry(QtCore.QRect(690, 540, 20, 41))
        self.line_127.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_127.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_127.setObjectName("line_127")
        self.line_128 = QtWidgets.QFrame(Form)
        self.line_128.setGeometry(QtCore.QRect(340, 540, 20, 41))
        self.line_128.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_128.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_128.setObjectName("line_128")
        self.line_129 = QtWidgets.QFrame(Form)
        self.line_129.setGeometry(QtCore.QRect(740, 540, 20, 41))
        self.line_129.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_129.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_129.setObjectName("line_129")
        self.line_130 = QtWidgets.QFrame(Form)
        self.line_130.setGeometry(QtCore.QRect(50, 570, 1061, 20))
        self.line_130.setFrameShape(QtWidgets.QFrame.HLine)
        self.line_130.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_130.setObjectName("line_130")
        self.label_shipDate9 = QtWidgets.QLabel(Form)
        self.label_shipDate9.setGeometry(QtCore.QRect(60, 550, 71, 21))
        self.label_shipDate9.setObjectName("label_shipDate9")
        self.label_customer9 = QtWidgets.QLabel(Form)
        self.label_customer9.setGeometry(QtCore.QRect(150, 540, 191, 41))
        self.label_customer9.setObjectName("label_customer9")
        self.line_131 = QtWidgets.QFrame(Form)
        self.line_131.setGeometry(QtCore.QRect(40, 540, 20, 41))
        self.line_131.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_131.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_131.setObjectName("line_131")
        self.line_132 = QtWidgets.QFrame(Form)
        self.line_132.setGeometry(QtCore.QRect(530, 540, 20, 41))
        self.line_132.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_132.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_132.setObjectName("line_132")
        self.label_payRemind9 = QtWidgets.QLabel(Form)
        self.label_payRemind9.setGeometry(QtCore.QRect(1020, 550, 81, 21))
        self.label_payRemind9.setObjectName("label_payRemind9")
        self.label_order9 = QtWidgets.QLabel(Form)
        self.label_order9.setGeometry(QtCore.QRect(10, 550, 31, 21))
        self.label_order9.setObjectName("label_order9")
        self.label_unitPrice9 = QtWidgets.QLabel(Form)
        self.label_unitPrice9.setGeometry(QtCore.QRect(620, 540, 71, 41))
        self.label_unitPrice9.setObjectName("label_unitPrice9")
        self.label_model9 = QtWidgets.QLabel(Form)
        self.label_model9.setGeometry(QtCore.QRect(470, 550, 61, 21))
        self.label_model9.setObjectName("label_model9")
        self.line_133 = QtWidgets.QFrame(Form)
        self.line_133.setGeometry(QtCore.QRect(1100, 540, 20, 41))
        self.line_133.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_133.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_133.setObjectName("line_133")
        self.line_134 = QtWidgets.QFrame(Form)
        self.line_134.setGeometry(QtCore.QRect(130, 540, 20, 41))
        self.line_134.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_134.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_134.setObjectName("line_134")
        self.label_amount9 = QtWidgets.QLabel(Form)
        self.label_amount9.setGeometry(QtCore.QRect(760, 540, 71, 41))
        self.label_amount9.setObjectName("label_amount9")
        self.line_135 = QtWidgets.QFrame(Form)
        self.line_135.setGeometry(QtCore.QRect(450, 590, 20, 41))
        self.line_135.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_135.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_135.setObjectName("line_135")
        self.label_receivable10 = QtWidgets.QLabel(Form)
        self.label_receivable10.setGeometry(QtCore.QRect(930, 600, 71, 21))
        self.label_receivable10.setObjectName("label_receivable10")
        self.line_136 = QtWidgets.QFrame(Form)
        self.line_136.setGeometry(QtCore.QRect(830, 590, 20, 41))
        self.line_136.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_136.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_136.setObjectName("line_136")
        self.label_production10 = QtWidgets.QLabel(Form)
        self.label_production10.setGeometry(QtCore.QRect(360, 600, 91, 21))
        self.label_production10.setObjectName("label_production10")
        self.label_number10 = QtWidgets.QLabel(Form)
        self.label_number10.setGeometry(QtCore.QRect(720, 600, 21, 21))
        self.label_number10.setObjectName("label_number10")
        self.label_macID10 = QtWidgets.QLabel(Form)
        self.label_macID10.setGeometry(QtCore.QRect(550, 600, 51, 21))
        self.label_macID10.setObjectName("label_macID10")
        self.line_137 = QtWidgets.QFrame(Form)
        self.line_137.setGeometry(QtCore.QRect(600, 590, 20, 41))
        self.line_137.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_137.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_137.setObjectName("line_137")
        self.line_138 = QtWidgets.QFrame(Form)
        self.line_138.setGeometry(QtCore.QRect(1000, 590, 20, 41))
        self.line_138.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_138.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_138.setObjectName("line_138")
        self.pushButton_edit10 = QtWidgets.QPushButton(Form)
        self.pushButton_edit10.setGeometry(QtCore.QRect(1130, 600, 71, 23))
        self.pushButton_edit10.setObjectName("pushButton_edit10")
        self.label_paid10 = QtWidgets.QLabel(Form)
        self.label_paid10.setGeometry(QtCore.QRect(850, 600, 61, 21))
        self.label_paid10.setObjectName("label_paid10")
        self.line_139 = QtWidgets.QFrame(Form)
        self.line_139.setGeometry(QtCore.QRect(910, 590, 20, 41))
        self.line_139.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_139.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_139.setObjectName("line_139")
        self.line_140 = QtWidgets.QFrame(Form)
        self.line_140.setGeometry(QtCore.QRect(50, 580, 1061, 20))
        self.line_140.setFrameShape(QtWidgets.QFrame.HLine)
        self.line_140.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_140.setObjectName("line_140")
        self.line_141 = QtWidgets.QFrame(Form)
        self.line_141.setGeometry(QtCore.QRect(690, 590, 20, 41))
        self.line_141.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_141.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_141.setObjectName("line_141")
        self.line_142 = QtWidgets.QFrame(Form)
        self.line_142.setGeometry(QtCore.QRect(340, 590, 20, 41))
        self.line_142.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_142.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_142.setObjectName("line_142")
        self.line_143 = QtWidgets.QFrame(Form)
        self.line_143.setGeometry(QtCore.QRect(740, 590, 20, 41))
        self.line_143.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_143.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_143.setObjectName("line_143")
        self.line_144 = QtWidgets.QFrame(Form)
        self.line_144.setGeometry(QtCore.QRect(50, 620, 1061, 20))
        self.line_144.setFrameShape(QtWidgets.QFrame.HLine)
        self.line_144.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_144.setObjectName("line_144")
        self.label_shipDate10 = QtWidgets.QLabel(Form)
        self.label_shipDate10.setGeometry(QtCore.QRect(60, 600, 71, 21))
        self.label_shipDate10.setObjectName("label_shipDate10")
        self.label_customer10 = QtWidgets.QLabel(Form)
        self.label_customer10.setGeometry(QtCore.QRect(150, 590, 191, 41))
        self.label_customer10.setObjectName("label_customer10")
        self.line_145 = QtWidgets.QFrame(Form)
        self.line_145.setGeometry(QtCore.QRect(40, 590, 20, 41))
        self.line_145.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_145.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_145.setObjectName("line_145")
        self.line_146 = QtWidgets.QFrame(Form)
        self.line_146.setGeometry(QtCore.QRect(530, 590, 20, 41))
        self.line_146.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_146.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_146.setObjectName("line_146")
        self.label_payRemind10 = QtWidgets.QLabel(Form)
        self.label_payRemind10.setGeometry(QtCore.QRect(1020, 600, 81, 21))
        self.label_payRemind10.setObjectName("label_payRemind10")
        self.label_order10 = QtWidgets.QLabel(Form)
        self.label_order10.setGeometry(QtCore.QRect(10, 600, 31, 21))
        self.label_order10.setObjectName("label_order10")
        self.label_unitPrice10 = QtWidgets.QLabel(Form)
        self.label_unitPrice10.setGeometry(QtCore.QRect(620, 590, 71, 41))
        self.label_unitPrice10.setObjectName("label_unitPrice10")
        self.label_model10 = QtWidgets.QLabel(Form)
        self.label_model10.setGeometry(QtCore.QRect(470, 600, 61, 21))
        self.label_model10.setObjectName("label_model10")
        self.line_147 = QtWidgets.QFrame(Form)
        self.line_147.setGeometry(QtCore.QRect(1100, 590, 20, 41))
        self.line_147.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_147.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_147.setObjectName("line_147")
        self.line_148 = QtWidgets.QFrame(Form)
        self.line_148.setGeometry(QtCore.QRect(130, 590, 20, 41))
        self.line_148.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_148.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_148.setObjectName("line_148")
        self.label_amount10 = QtWidgets.QLabel(Form)
        self.label_amount10.setGeometry(QtCore.QRect(760, 590, 71, 41))
        self.label_amount10.setObjectName("label_amount10")
        self.pushButton_advSearch = QtWidgets.QPushButton(Form)
        self.pushButton_advSearch.setGeometry(QtCore.QRect(210, 20, 91, 21))
        self.pushButton_advSearch.setObjectName("pushButton_advSearch")
        self.line_149 = QtWidgets.QFrame(Form)
        self.line_149.setGeometry(QtCore.QRect(40, 80, 20, 51))
        self.line_149.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_149.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_149.setObjectName("line_149")
        self.line_150 = QtWidgets.QFrame(Form)
        self.line_150.setGeometry(QtCore.QRect(1100, 80, 20, 51))
        self.line_150.setFrameShape(QtWidgets.QFrame.VLine)
        self.line_150.setFrameShadow(QtWidgets.QFrame.Sunken)
        self.line_150.setObjectName("line_150")
        self.pushButton_toPay = QtWidgets.QPushButton(Form)
        self.pushButton_toPay.setGeometry(QtCore.QRect(310, 20, 81, 23))
        self.pushButton_toPay.setObjectName("pushButton_toPay")
        self.label_id2 = QtWidgets.QLabel(Form)
        self.label_id2.setGeometry(QtCore.QRect(1120, 220, 71, 21))
        self.label_id2.setText("")
        self.label_id2.setObjectName("label_id2")
        self.label_id4 = QtWidgets.QLabel(Form)
        self.label_id4.setGeometry(QtCore.QRect(1120, 320, 71, 21))
        self.label_id4.setText("")
        self.label_id4.setObjectName("label_id4")
        self.label_id9 = QtWidgets.QLabel(Form)
        self.label_id9.setGeometry(QtCore.QRect(1120, 570, 71, 21))
        self.label_id9.setText("")
        self.label_id9.setObjectName("label_id9")
        self.label_id3 = QtWidgets.QLabel(Form)
        self.label_id3.setGeometry(QtCore.QRect(1120, 270, 71, 21))
        self.label_id3.setText("")
        self.label_id3.setObjectName("label_id3")
        self.label_id6 = QtWidgets.QLabel(Form)
        self.label_id6.setGeometry(QtCore.QRect(1120, 420, 71, 21))
        self.label_id6.setText("")
        self.label_id6.setObjectName("label_id6")
        self.label_id7 = QtWidgets.QLabel(Form)
        self.label_id7.setGeometry(QtCore.QRect(1120, 470, 71, 21))
        self.label_id7.setText("")
        self.label_id7.setObjectName("label_id7")
        self.label_id5 = QtWidgets.QLabel(Form)
        self.label_id5.setGeometry(QtCore.QRect(1120, 370, 71, 21))
        self.label_id5.setText("")
        self.label_id5.setObjectName("label_id5")
        self.label_id8 = QtWidgets.QLabel(Form)
        self.label_id8.setGeometry(QtCore.QRect(1120, 520, 71, 21))
        self.label_id8.setText("")
        self.label_id8.setObjectName("label_id8")
        self.label_id10 = QtWidgets.QLabel(Form)
        self.label_id10.setGeometry(QtCore.QRect(1120, 620, 71, 21))
        self.label_id10.setText("")
        self.label_id10.setObjectName("label_id10")
        self.label_id1 = QtWidgets.QLabel(Form)
        self.label_id1.setGeometry(QtCore.QRect(1120, 170, 71, 21))
        self.label_id1.setText("")
        self.label_id1.setObjectName("label_id1")
        self.toolButton = QtWidgets.QToolButton(Form)
        self.toolButton.setGeometry(QtCore.QRect(1150, 20, 36, 36))
        icon = QtGui.QIcon()
        icon.addPixmap(QtGui.QPixmap("../tim.gif"), QtGui.QIcon.Normal, QtGui.QIcon.Off)
        self.toolButton.setIcon(icon)
        self.toolButton.setIconSize(QtCore.QSize(32, 32))
        self.toolButton.setObjectName("toolButton")
        self.label_3 = QtWidgets.QLabel(Form)
        self.label_3.setGeometry(QtCore.QRect(1150, 60, 51, 31))
        self.label_3.setObjectName("label_3")
        self.label_receivableTotal = QtWidgets.QLabel(Form)
        self.label_receivableTotal.setGeometry(QtCore.QRect(920, 650, 91, 21))
        self.label_receivableTotal.setObjectName("label_receivableTotal")
        self.label_21 = QtWidgets.QLabel(Form)
        self.label_21.setGeometry(QtCore.QRect(880, 640, 31, 39))
        self.label_21.setObjectName("label_21")
        self.label_13.raise_()
        self.lineEdit_search.raise_()
        self.label_customer1.raise_()
        self.line_7.raise_()
        self.pushButton_SwitchCustomer.raise_()
        self.label_4.raise_()
        self.pushButton_SwitchService.raise_()
        self.label_8.raise_()
        self.label_5.raise_()
        self.label_2.raise_()
        self.pushButton_previous.raise_()
        self.pushButton_next.raise_()
        self.pushButton_new.raise_()
        self.pushButton_jump.raise_()
        self.label_9.raise_()
        self.lineEdit_jump.raise_()
        self.label_11.raise_()
        self.label_14.raise_()
        self.label_shipDate1.raise_()
        self.label_production1.raise_()
        self.label_model1.raise_()
        self.label_15.raise_()
        self.label_macID1.raise_()
        self.label_16.raise_()
        self.label_17.raise_()
        self.label_18.raise_()
        self.label_number1.raise_()
        self.label_unitPrice1.raise_()
        self.label_amount1.raise_()
        self.label_19.raise_()
        self.label_paid1.raise_()
        self.label_20.raise_()
        self.label_receivable1.raise_()
        self.label_payRemind1.raise_()
        self.line_10.raise_()
        self.line_11.raise_()
        self.pushButton_search.raise_()
        self.pushButton_SwitchShipment.raise_()
        self.label_22.raise_()
        self.label_cPage.raise_()
        self.label_tPage.raise_()
        self.label_order1.raise_()
        self.line_8.raise_()
        self.line_12.raise_()
        self.line_13.raise_()
        self.line_14.raise_()
        self.line_15.raise_()
        self.line_16.raise_()
        self.line_17.raise_()
        self.line_18.raise_()
        self.line_19.raise_()
        self.line_20.raise_()
        self.line_21.raise_()
        self.line_22.raise_()
        self.pushButton_edit1.raise_()
        self.line_23.raise_()
        self.label_receivable2.raise_()
        self.line_24.raise_()
        self.label_production2.raise_()
        self.label_number2.raise_()
        self.label_macID2.raise_()
        self.line_25.raise_()
        self.line_26.raise_()
        self.pushButton_edit2.raise_()
        self.label_paid2.raise_()
        self.line_27.raise_()
        self.line_28.raise_()
        self.line_29.raise_()
        self.line_30.raise_()
        self.line_31.raise_()
        self.line_32.raise_()
        self.label_shipDate2.raise_()
        self.label_customer2.raise_()
        self.line_33.raise_()
        self.line_34.raise_()
        self.label_payRemind2.raise_()
        self.label_order2.raise_()
        self.label_unitPrice2.raise_()
        self.label_model2.raise_()
        self.line_35.raise_()
        self.line_36.raise_()
        self.label_amount2.raise_()
        self.line_37.raise_()
        self.label_receivable3.raise_()
        self.line_38.raise_()
        self.label_production3.raise_()
        self.label_number3.raise_()
        self.label_macID3.raise_()
        self.line_39.raise_()
        self.line_40.raise_()
        self.pushButton_edit3.raise_()
        self.label_paid3.raise_()
        self.line_41.raise_()
        self.line_42.raise_()
        self.line_43.raise_()
        self.line_44.raise_()
        self.line_45.raise_()
        self.line_46.raise_()
        self.label_shipDate3.raise_()
        self.label_customer3.raise_()
        self.line_47.raise_()
        self.line_48.raise_()
        self.label_payRemind3.raise_()
        self.label_order3.raise_()
        self.label_unitPrice3.raise_()
        self.label_model3.raise_()
        self.line_49.raise_()
        self.line_50.raise_()
        self.label_amount3.raise_()
        self.line_51.raise_()
        self.label_receivable4.raise_()
        self.line_52.raise_()
        self.label_production4.raise_()
        self.label_number4.raise_()
        self.label_macID4.raise_()
        self.line_53.raise_()
        self.line_54.raise_()
        self.pushButton_edit4.raise_()
        self.label_paid4.raise_()
        self.line_55.raise_()
        self.line_56.raise_()
        self.line_57.raise_()
        self.line_58.raise_()
        self.line_59.raise_()
        self.line_60.raise_()
        self.label_shipDate4.raise_()
        self.label_customer4.raise_()
        self.line_61.raise_()
        self.line_62.raise_()
        self.label_payRemind4.raise_()
        self.label_order4.raise_()
        self.label_unitPrice4.raise_()
        self.label_model4.raise_()
        self.line_63.raise_()
        self.line_64.raise_()
        self.label_amount4.raise_()
        self.line_65.raise_()
        self.label_receivable5.raise_()
        self.line_66.raise_()
        self.label_production5.raise_()
        self.label_number5.raise_()
        self.label_macID5.raise_()
        self.line_67.raise_()
        self.line_68.raise_()
        self.pushButton_edit5.raise_()
        self.label_paid5.raise_()
        self.line_69.raise_()
        self.line_70.raise_()
        self.line_71.raise_()
        self.line_72.raise_()
        self.line_73.raise_()
        self.line_74.raise_()
        self.label_shipDate5.raise_()
        self.label_customer5.raise_()
        self.line_75.raise_()
        self.line_76.raise_()
        self.label_payRemind5.raise_()
        self.label_order5.raise_()
        self.label_unitPrice5.raise_()
        self.label_model5.raise_()
        self.line_77.raise_()
        self.line_78.raise_()
        self.label_amount5.raise_()
        self.line_79.raise_()
        self.label_receivable6.raise_()
        self.line_80.raise_()
        self.label_production6.raise_()
        self.label_number6.raise_()
        self.label_macID6.raise_()
        self.line_81.raise_()
        self.line_82.raise_()
        self.pushButton_edit6.raise_()
        self.label_paid6.raise_()
        self.line_83.raise_()
        self.line_84.raise_()
        self.line_85.raise_()
        self.line_86.raise_()
        self.line_87.raise_()
        self.line_88.raise_()
        self.label_shipDate6.raise_()
        self.label_customer6.raise_()
        self.line_89.raise_()
        self.line_90.raise_()
        self.label_payRemind6.raise_()
        self.label_order6.raise_()
        self.label_unitPrice6.raise_()
        self.label_model6.raise_()
        self.line_91.raise_()
        self.line_92.raise_()
        self.label_amount6.raise_()
        self.line_93.raise_()
        self.label_receivable7.raise_()
        self.line_94.raise_()
        self.label_production7.raise_()
        self.label_number7.raise_()
        self.label_macID7.raise_()
        self.line_95.raise_()
        self.line_96.raise_()
        self.pushButton_edit7.raise_()
        self.label_paid7.raise_()
        self.line_97.raise_()
        self.line_98.raise_()
        self.line_99.raise_()
        self.line_100.raise_()
        self.line_101.raise_()
        self.line_102.raise_()
        self.label_shipDate7.raise_()
        self.label_customer7.raise_()
        self.line_103.raise_()
        self.line_104.raise_()
        self.label_payRemind7.raise_()
        self.label_order7.raise_()
        self.label_unitPrice7.raise_()
        self.label_model7.raise_()
        self.line_105.raise_()
        self.line_106.raise_()
        self.label_amount7.raise_()
        self.line_107.raise_()
        self.label_receivable8.raise_()
        self.line_108.raise_()
        self.label_production8.raise_()
        self.label_number8.raise_()
        self.label_macID8.raise_()
        self.line_109.raise_()
        self.line_110.raise_()
        self.pushButton_edit8.raise_()
        self.label_paid8.raise_()
        self.line_111.raise_()
        self.line_112.raise_()
        self.line_113.raise_()
        self.line_114.raise_()
        self.line_115.raise_()
        self.line_116.raise_()
        self.label_shipDate8.raise_()
        self.label_customer8.raise_()
        self.line_117.raise_()
        self.line_118.raise_()
        self.label_payRemind8.raise_()
        self.label_order8.raise_()
        self.label_unitPrice8.raise_()
        self.label_model8.raise_()
        self.line_119.raise_()
        self.line_120.raise_()
        self.label_amount8.raise_()
        self.line_121.raise_()
        self.label_receivable9.raise_()
        self.line_122.raise_()
        self.label_production9.raise_()
        self.label_number9.raise_()
        self.label_macID9.raise_()
        self.line_123.raise_()
        self.line_124.raise_()
        self.pushButton_edit9.raise_()
        self.label_paid9.raise_()
        self.line_125.raise_()
        self.line_126.raise_()
        self.line_127.raise_()
        self.line_128.raise_()
        self.line_129.raise_()
        self.line_130.raise_()
        self.label_shipDate9.raise_()
        self.label_customer9.raise_()
        self.line_131.raise_()
        self.line_132.raise_()
        self.label_payRemind9.raise_()
        self.label_order9.raise_()
        self.label_unitPrice9.raise_()
        self.label_model9.raise_()
        self.line_133.raise_()
        self.line_134.raise_()
        self.label_amount9.raise_()
        self.line_135.raise_()
        self.label_receivable10.raise_()
        self.line_136.raise_()
        self.label_production10.raise_()
        self.label_number10.raise_()
        self.label_macID10.raise_()
        self.line_137.raise_()
        self.line_138.raise_()
        self.pushButton_edit10.raise_()
        self.label_paid10.raise_()
        self.line_139.raise_()
        self.line_140.raise_()
        self.line_141.raise_()
        self.line_142.raise_()
        self.line_143.raise_()
        self.line_144.raise_()
        self.label_shipDate10.raise_()
        self.label_customer10.raise_()
        self.line_145.raise_()
        self.line_146.raise_()
        self.label_payRemind10.raise_()
        self.label_order10.raise_()
        self.label_unitPrice10.raise_()
        self.label_model10.raise_()
        self.line_147.raise_()
        self.line_148.raise_()
        self.label_amount10.raise_()
        self.pushButton_advSearch.raise_()
        self.line_149.raise_()
        self.line_150.raise_()
        self.pushButton_toPay.raise_()
        self.label_id2.raise_()
        self.label_id4.raise_()
        self.label_id9.raise_()
        self.label_id3.raise_()
        self.label_id6.raise_()
        self.label_id7.raise_()
        self.label_id5.raise_()
        self.label_id8.raise_()
        self.label_id10.raise_()
        self.label_id1.raise_()
        self.toolButton.raise_()
        self.label_3.raise_()
        self.label_receivableTotal.raise_()
        self.label_21.raise_()

        self.retranslateUi(Form)
        self.pushButton_previous.clicked.connect(Form.reloadWidgetDec)
        self.pushButton_next.clicked.connect(Form.reloadWidgetAdd)
        QtCore.QMetaObject.connectSlotsByName(Form)

    def retranslateUi(self, Form):
        _translate = QtCore.QCoreApplication.translate
        Form.setWindowTitle(_translate("Form", "Form"))
        self.label_13.setText(_translate("Form", "<html><head/><body><p align=\"center\"><span style=\" font-size:18pt; font-weight:600; color:#0b3da8;\">产品出货记录</span></p></body></html>"))
        self.label_customer1.setText(_translate("Form", "<html><head/><body><p><span style=\" color:#000000;\">customer</span></p></body></html>"))
        self.pushButton_SwitchCustomer.setText(_translate("Form", "客户信息界面"))
        self.label_4.setText(_translate("Form", "<html><head/><body><p><span style=\" font-size:10pt; font-weight:600;\">出货产品</span></p></body></html>"))
        self.pushButton_SwitchService.setText(_translate("Form", "售后服务记录"))
        self.label_8.setText(_translate("Form", "客户搜索"))
        self.label_5.setText(_translate("Form", "<html><head/><body><p><span style=\" font-size:10pt; font-weight:600;\">规格型号</span></p></body></html>"))
        self.label_2.setText(_translate("Form", "<html><head/><body><p><span style=\" font-size:10pt; font-weight:600;\">出货日期</span></p></body></html>"))
        self.pushButton_previous.setText(_translate("Form", "上一页"))
        self.pushButton_next.setText(_translate("Form", "下一页"))
        self.pushButton_new.setText(_translate("Form", "新增出货信息"))
        self.pushButton_jump.setText(_translate("Form", "GO!"))
        self.label_9.setText(_translate("Form", "跳到第       页"))
        self.label_11.setText(_translate("Form", "<html><head/><body><p><span style=\" font-size:10pt; font-weight:600;\">下次付款</span></p></body></html>"))
        self.label_14.setText(_translate("Form", "<html><head/><body><p><span style=\" font-size:10pt; font-weight:600;\">客户名称</span></p></body></html>"))
        self.label_shipDate1.setText(_translate("Form", "shipDate"))
        self.label_production1.setText(_translate("Form", "<html><head/><body><p align=\"center\"><span style=\" color:#000000;\">production</span></p></body></html>"))
        self.label_model1.setText(_translate("Form", "<html><head/><body><p align=\"center\">macID</p></body></html>"))
        self.label_15.setText(_translate("Form", "<html><head/><body><p><span style=\" font-size:10pt; font-weight:600;\">设备号</span></p></body></html>"))
        self.label_macID1.setText(_translate("Form", "<html><head/><body><p align=\"center\">macID</p></body></html>"))
        self.label_16.setText(_translate("Form", "<html><head/><body><p><span style=\" font-size:10pt; font-weight:600;\">数量</span></p></body></html>"))
        self.label_17.setText(_translate("Form", "<html><head/><body><p><span style=\" font-size:10pt; font-weight:600;\">单价</span></p></body></html>"))
        self.label_18.setText(_translate("Form", "<html><head/><body><p><span style=\" font-size:10pt; font-weight:600;\">金额</span></p></body></html>"))
        self.label_number1.setText(_translate("Form", "number"))
        self.label_unitPrice1.setText(_translate("Form", "<html><head/><body><p align=\"right\">unitPrice</p></body></html>"))
        self.label_amount1.setText(_translate("Form", "<html><head/><body><p align=\"right\">amount</p></body></html>"))
        self.label_19.setText(_translate("Form", "<html><head/><body><p><span style=\" font-size:10pt; font-weight:600;\">已付款</span></p></body></html>"))
        self.label_paid1.setText(_translate("Form", "<html><head/><body><p align=\"right\">paid</p></body></html>"))
        self.label_20.setText(_translate("Form", "<html><head/><body><p><span style=\" font-size:10pt; font-weight:600;\">应收款</span></p></body></html>"))
        self.label_receivable1.setText(_translate("Form", "<html><head/><body><p align=\"right\">receivable</p></body></html>"))
        self.label_payRemind1.setText(_translate("Form", "<html><head/><body><p align=\"center\">payRemind</p></body></html>"))
        self.pushButton_search.setText(_translate("Form", "GO!"))
        self.pushButton_SwitchShipment.setText(_translate("Form", "产品出货信息"))
        self.label_22.setText(_translate("Form", "第        /         页"))
        self.label_cPage.setText(_translate("Form", "<html><head/><body><p><span style=\" font-size:10pt; color:#063661;\">cPage</span></p></body></html>"))
        self.label_tPage.setText(_translate("Form", "<html><head/><body><p><span style=\" font-size:10pt; color:#063661;\">tPage</span></p></body></html>"))
        self.label_order1.setText(_translate("Form", "order"))
        self.pushButton_edit1.setText(_translate("Form", "详细信息"))
        self.label_receivable2.setText(_translate("Form", "<html><head/><body><p align=\"right\">receivable</p></body></html>"))
        self.label_production2.setText(_translate("Form", "<html><head/><body><p align=\"center\"><span style=\" color:#000000;\">production</span></p></body></html>"))
        self.label_number2.setText(_translate("Form", "number"))
        self.label_macID2.setText(_translate("Form", "<html><head/><body><p align=\"center\">macID</p></body></html>"))
        self.pushButton_edit2.setText(_translate("Form", "详细信息"))
        self.label_paid2.setText(_translate("Form", "<html><head/><body><p align=\"right\">paid</p></body></html>"))
        self.label_shipDate2.setText(_translate("Form", "shipDate"))
        self.label_customer2.setText(_translate("Form", "<html><head/><body><p><span style=\" color:#000000;\">customer</span></p></body></html>"))
        self.label_payRemind2.setText(_translate("Form", "<html><head/><body><p align=\"center\">payRemind</p></body></html>"))
        self.label_order2.setText(_translate("Form", "order"))
        self.label_unitPrice2.setText(_translate("Form", "<html><head/><body><p align=\"right\">unitPrice</p></body></html>"))
        self.label_model2.setText(_translate("Form", "<html><head/><body><p align=\"center\">macID</p></body></html>"))
        self.label_amount2.setText(_translate("Form", "<html><head/><body><p align=\"right\">amount</p></body></html>"))
        self.label_receivable3.setText(_translate("Form", "<html><head/><body><p align=\"right\">receivable</p></body></html>"))
        self.label_production3.setText(_translate("Form", "<html><head/><body><p align=\"center\"><span style=\" color:#000000;\">production</span></p></body></html>"))
        self.label_number3.setText(_translate("Form", "number"))
        self.label_macID3.setText(_translate("Form", "<html><head/><body><p align=\"center\">macID</p></body></html>"))
        self.pushButton_edit3.setText(_translate("Form", "详细信息"))
        self.label_paid3.setText(_translate("Form", "<html><head/><body><p align=\"right\">paid</p></body></html>"))
        self.label_shipDate3.setText(_translate("Form", "shipDate"))
        self.label_customer3.setText(_translate("Form", "<html><head/><body><p><span style=\" color:#000000;\">customer</span></p></body></html>"))
        self.label_payRemind3.setText(_translate("Form", "<html><head/><body><p align=\"center\">payRemind</p></body></html>"))
        self.label_order3.setText(_translate("Form", "order"))
        self.label_unitPrice3.setText(_translate("Form", "<html><head/><body><p align=\"right\">unitPrice</p></body></html>"))
        self.label_model3.setText(_translate("Form", "<html><head/><body><p align=\"center\">macID</p></body></html>"))
        self.label_amount3.setText(_translate("Form", "<html><head/><body><p align=\"right\">amount</p></body></html>"))
        self.label_receivable4.setText(_translate("Form", "<html><head/><body><p align=\"right\">receivable</p></body></html>"))
        self.label_production4.setText(_translate("Form", "<html><head/><body><p align=\"center\"><span style=\" color:#000000;\">production</span></p></body></html>"))
        self.label_number4.setText(_translate("Form", "number"))
        self.label_macID4.setText(_translate("Form", "<html><head/><body><p align=\"center\">macID</p></body></html>"))
        self.pushButton_edit4.setText(_translate("Form", "详细信息"))
        self.label_paid4.setText(_translate("Form", "<html><head/><body><p align=\"right\">paid</p></body></html>"))
        self.label_shipDate4.setText(_translate("Form", "shipDate"))
        self.label_customer4.setText(_translate("Form", "<html><head/><body><p><span style=\" color:#000000;\">customer</span></p></body></html>"))
        self.label_payRemind4.setText(_translate("Form", "<html><head/><body><p align=\"center\">payRemind</p></body></html>"))
        self.label_order4.setText(_translate("Form", "order"))
        self.label_unitPrice4.setText(_translate("Form", "<html><head/><body><p align=\"right\">unitPrice</p></body></html>"))
        self.label_model4.setText(_translate("Form", "<html><head/><body><p align=\"center\">macID</p></body></html>"))
        self.label_amount4.setText(_translate("Form", "<html><head/><body><p align=\"right\">amount</p></body></html>"))
        self.label_receivable5.setText(_translate("Form", "<html><head/><body><p align=\"right\">receivable</p></body></html>"))
        self.label_production5.setText(_translate("Form", "<html><head/><body><p align=\"center\"><span style=\" color:#000000;\">production</span></p></body></html>"))
        self.label_number5.setText(_translate("Form", "number"))
        self.label_macID5.setText(_translate("Form", "<html><head/><body><p align=\"center\">macID</p></body></html>"))
        self.pushButton_edit5.setText(_translate("Form", "详细信息"))
        self.label_paid5.setText(_translate("Form", "<html><head/><body><p align=\"right\">paid</p></body></html>"))
        self.label_shipDate5.setText(_translate("Form", "shipDate"))
        self.label_customer5.setText(_translate("Form", "<html><head/><body><p><span style=\" color:#000000;\">customer</span></p></body></html>"))
        self.label_payRemind5.setText(_translate("Form", "<html><head/><body><p align=\"center\">payRemind</p></body></html>"))
        self.label_order5.setText(_translate("Form", "order"))
        self.label_unitPrice5.setText(_translate("Form", "<html><head/><body><p align=\"right\">unitPrice</p></body></html>"))
        self.label_model5.setText(_translate("Form", "<html><head/><body><p align=\"center\">macID</p></body></html>"))
        self.label_amount5.setText(_translate("Form", "<html><head/><body><p align=\"right\">amount</p></body></html>"))
        self.label_receivable6.setText(_translate("Form", "<html><head/><body><p align=\"right\">receivable</p></body></html>"))
        self.label_production6.setText(_translate("Form", "<html><head/><body><p align=\"center\"><span style=\" color:#000000;\">production</span></p></body></html>"))
        self.label_number6.setText(_translate("Form", "number"))
        self.label_macID6.setText(_translate("Form", "<html><head/><body><p align=\"center\">macID</p></body></html>"))
        self.pushButton_edit6.setText(_translate("Form", "详细信息"))
        self.label_paid6.setText(_translate("Form", "<html><head/><body><p align=\"right\">paid</p></body></html>"))
        self.label_shipDate6.setText(_translate("Form", "shipDate"))
        self.label_customer6.setText(_translate("Form", "<html><head/><body><p><span style=\" color:#000000;\">customer</span></p></body></html>"))
        self.label_payRemind6.setText(_translate("Form", "<html><head/><body><p align=\"center\">payRemind</p></body></html>"))
        self.label_order6.setText(_translate("Form", "order"))
        self.label_unitPrice6.setText(_translate("Form", "<html><head/><body><p align=\"right\">unitPrice</p></body></html>"))
        self.label_model6.setText(_translate("Form", "<html><head/><body><p align=\"center\">macID</p></body></html>"))
        self.label_amount6.setText(_translate("Form", "<html><head/><body><p align=\"right\">amount</p></body></html>"))
        self.label_receivable7.setText(_translate("Form", "<html><head/><body><p align=\"right\">receivable</p></body></html>"))
        self.label_production7.setText(_translate("Form", "<html><head/><body><p align=\"center\"><span style=\" color:#000000;\">production</span></p></body></html>"))
        self.label_number7.setText(_translate("Form", "number"))
        self.label_macID7.setText(_translate("Form", "<html><head/><body><p align=\"center\">macID</p></body></html>"))
        self.pushButton_edit7.setText(_translate("Form", "详细信息"))
        self.label_paid7.setText(_translate("Form", "<html><head/><body><p align=\"right\">paid</p></body></html>"))
        self.label_shipDate7.setText(_translate("Form", "shipDate"))
        self.label_customer7.setText(_translate("Form", "<html><head/><body><p><span style=\" color:#000000;\">customer</span></p></body></html>"))
        self.label_payRemind7.setText(_translate("Form", "<html><head/><body><p align=\"center\">payRemind</p></body></html>"))
        self.label_order7.setText(_translate("Form", "order"))
        self.label_unitPrice7.setText(_translate("Form", "<html><head/><body><p align=\"right\">unitPrice</p></body></html>"))
        self.label_model7.setText(_translate("Form", "<html><head/><body><p align=\"center\">macID</p></body></html>"))
        self.label_amount7.setText(_translate("Form", "<html><head/><body><p align=\"right\">amount</p></body></html>"))
        self.label_receivable8.setText(_translate("Form", "<html><head/><body><p align=\"right\">receivable</p></body></html>"))
        self.label_production8.setText(_translate("Form", "<html><head/><body><p align=\"center\"><span style=\" color:#000000;\">production</span></p></body></html>"))
        self.label_number8.setText(_translate("Form", "number"))
        self.label_macID8.setText(_translate("Form", "<html><head/><body><p align=\"center\">macID</p></body></html>"))
        self.pushButton_edit8.setText(_translate("Form", "详细信息"))
        self.label_paid8.setText(_translate("Form", "<html><head/><body><p align=\"right\">paid</p></body></html>"))
        self.label_shipDate8.setText(_translate("Form", "shipDate"))
        self.label_customer8.setText(_translate("Form", "<html><head/><body><p><span style=\" color:#000000;\">customer</span></p></body></html>"))
        self.label_payRemind8.setText(_translate("Form", "<html><head/><body><p align=\"center\">payRemind</p></body></html>"))
        self.label_order8.setText(_translate("Form", "order"))
        self.label_unitPrice8.setText(_translate("Form", "<html><head/><body><p align=\"right\">unitPrice</p></body></html>"))
        self.label_model8.setText(_translate("Form", "<html><head/><body><p align=\"center\">macID</p></body></html>"))
        self.label_amount8.setText(_translate("Form", "<html><head/><body><p align=\"right\">amount</p></body></html>"))
        self.label_receivable9.setText(_translate("Form", "<html><head/><body><p align=\"right\">receivable</p></body></html>"))
        self.label_production9.setText(_translate("Form", "<html><head/><body><p align=\"center\"><span style=\" color:#000000;\">production</span></p></body></html>"))
        self.label_number9.setText(_translate("Form", "number"))
        self.label_macID9.setText(_translate("Form", "<html><head/><body><p align=\"center\">macID</p></body></html>"))
        self.pushButton_edit9.setText(_translate("Form", "详细信息"))
        self.label_paid9.setText(_translate("Form", "<html><head/><body><p align=\"right\">paid</p></body></html>"))
        self.label_shipDate9.setText(_translate("Form", "shipDate"))
        self.label_customer9.setText(_translate("Form", "<html><head/><body><p><span style=\" color:#000000;\">customer</span></p></body></html>"))
        self.label_payRemind9.setText(_translate("Form", "<html><head/><body><p align=\"center\">payRemind</p></body></html>"))
        self.label_order9.setText(_translate("Form", "order"))
        self.label_unitPrice9.setText(_translate("Form", "<html><head/><body><p align=\"right\">unitPrice</p></body></html>"))
        self.label_model9.setText(_translate("Form", "<html><head/><body><p align=\"center\">macID</p></body></html>"))
        self.label_amount9.setText(_translate("Form", "<html><head/><body><p align=\"right\">amount</p></body></html>"))
        self.label_receivable10.setText(_translate("Form", "<html><head/><body><p align=\"right\">receivable</p></body></html>"))
        self.label_production10.setText(_translate("Form", "<html><head/><body><p align=\"center\"><span style=\" color:#000000;\">production</span></p></body></html>"))
        self.label_number10.setText(_translate("Form", "number"))
        self.label_macID10.setText(_translate("Form", "<html><head/><body><p align=\"center\">macID</p></body></html>"))
        self.pushButton_edit10.setText(_translate("Form", "详细信息"))
        self.label_paid10.setText(_translate("Form", "<html><head/><body><p align=\"right\">paid</p></body></html>"))
        self.label_shipDate10.setText(_translate("Form", "shipDate"))
        self.label_customer10.setText(_translate("Form", "<html><head/><body><p><span style=\" color:#000000;\">customer</span></p></body></html>"))
        self.label_payRemind10.setText(_translate("Form", "<html><head/><body><p align=\"center\">payRemind</p></body></html>"))
        self.label_order10.setText(_translate("Form", "order"))
        self.label_unitPrice10.setText(_translate("Form", "<html><head/><body><p align=\"right\">unitPrice</p></body></html>"))
        self.label_model10.setText(_translate("Form", "<html><head/><body><p align=\"center\">macID</p></body></html>"))
        self.label_amount10.setText(_translate("Form", "<html><head/><body><p align=\"right\">amount</p></body></html>"))
        self.pushButton_advSearch.setText(_translate("Form", "显示全部记录"))
        self.pushButton_toPay.setText(_translate("Form", "应收款统计"))
        self.toolButton.setText(_translate("Form", "..."))
        self.label_3.setText(_translate("Form", "<html><head/><body><p>数据同步</p></body></html>"))
        self.label_receivableTotal.setText(_translate("Form", "<html><head/><body><p align=\"right\">receivable</p></body></html>"))
        self.label_21.setText(_translate("Form", "<html><head/><body><p>合计</p></body></html>"))


####以上为QTDesiger自动生成代码
###以下为自己写的代码
    def closeEvent(self, event):        #关闭窗口触发以下事件
        reply = QMessageBox.question(self, '消息提示', '你确定要退出吗?', QMessageBox.Yes | QMessageBox.No, QMessageBox.No)
        if reply == QMessageBox.Yes:
            event.accept()        #接受关闭事件
        else:
            event.ignore()        #忽略关闭事件
    def reloadWidgetAdd(self): #点击下一页触发
        global databaseFlag         #以下查看databaseFlag以判断当前使用的是哪个数据库。
        if databaseFlag==0:
            data=self.database() #如果m=0，则显示全部数据库内容
        elif databaseFlag==1:
            data=self.rdatabase()#如果m=1，则显示应收款客户列表
        else:
            data=self.sdatabase()#如果都不是，则读取搜索数据库内容
        i= int(self.label_order10.text())
        j=len(data) #数据库的总记录条数=j
        if i < j:
            global g
            g+=1 #全局变量P页数+1
            self.pageDisplay(0,g)
        else:
            print("remain")
    def reloadWidgetDec(self): #点击上一页触发
        global databaseFlag
        i= int(self.label_order10.text())
        if i > 10:
            global g
            g-=1 #全局变量P页数-1
            if databaseFlag==0:
                self.pageDisplay(0,g)
            elif databaseFlag==1:
                self.pageDisplay(1,g)
            else:
                self.pageDisplay(2,g)
        else:
            print("remain")

    def pageDisplay(self,m,g):  #本函数显示g页的数据
        print("shipment_browser:pageDisplay",g)
        global databaseFlag
        databaseFlag=m
        if m==0:
            data=self.database() #如果m=0，则显示全部数据库内容
        elif m==1:
            data=self.rdatabase()#如果m=1，则显示应收款客户列表
        else:
            data=self.sdatabase()#如果都不是，则读取搜索数据库内容

        self.pushButton_edit2.show() #显示开始，先把之前可能隐藏的按钮重新显示出来
        self.pushButton_edit3.show()
        self.pushButton_edit4.show()
        self.pushButton_edit5.show()
        self.pushButton_edit6.show()
        self.pushButton_edit7.show()
        self.pushButton_edit8.show()
        self.pushButton_edit9.show()
        self.pushButton_edit10.show()

        orderJ=g*10
        orderI=orderJ-1
        orderH=orderJ-2
        orderG=orderJ-3
        orderF=orderJ-4
        orderE=orderJ-5
        orderD=orderJ-6
        orderC=orderJ-7
        orderB=orderJ-8
        orderA=orderJ-9
        self.label_order1.setText(str(orderA))
        self.label_order2.setText(str(orderB))
        self.label_order3.setText(str(orderC))
        self.label_order4.setText(str(orderD))
        self.label_order5.setText(str(orderE))
        self.label_order6.setText(str(orderF))
        self.label_order7.setText(str(orderG))
        self.label_order8.setText(str(orderH))
        self.label_order9.setText(str(orderI))
        self.label_order10.setText(str(orderJ))

        dblen=len(data)
        p=g*10-9  #获得当前页面的第1行的序号
        blank=["","","","","","","","0","0","0","","","","","",""]
        print("shipment_browser-pageDisplay:现在数据库中共有记录：",dblen)
        a=dblen%10 #计算最后一页总共有几行？
        b=10-a  #计算空白的有几行
        while b>0:#将当前页面的空白记录行填充N/A，以免data赋值的时候不够5行导致出错
            data.append(blank)
            if g == dblen//10+1:  #如果当前页面是最后一页---总页数/10然后+1
                if b==1: #如果只有1行空白
                    self.pushButton_edit10.hide() #隐藏最后一个编辑按钮
                elif b==2:#如果有2行空白
                    self.pushButton_edit9.hide() #隐藏最后2个编辑按钮
                    self.pushButton_edit10.hide()
                elif b==3:#如果有3行空白
                    self.pushButton_edit8.hide() #隐藏最后2个编辑按钮
                    self.pushButton_edit9.hide() #隐藏最后2个编辑按钮
                    self.pushButton_edit10.hide()
                elif b==4:#如果有4行空白
                    self.pushButton_edit7.hide() #隐藏最后2个编辑按钮
                    self.pushButton_edit8.hide() #隐藏最后2个编辑按钮
                    self.pushButton_edit9.hide() #隐藏最后2个编辑按钮
                    self.pushButton_edit10.hide()
                elif b==5:#如果有5行空白
                    self.pushButton_edit6.hide() #隐藏最后2个编辑按钮
                    self.pushButton_edit7.hide() #隐藏最后2个编辑按钮
                    self.pushButton_edit8.hide() #隐藏最后2个编辑按钮
                    self.pushButton_edit9.hide() #隐藏最后2个编辑按钮
                    self.pushButton_edit10.hide()
                elif b==6:#如果有6行空白
                    self.pushButton_edit5.hide() #隐藏最后2个编辑按钮
                    self.pushButton_edit6.hide() #隐藏最后2个编辑按钮
                    self.pushButton_edit7.hide() #隐藏最后2个编辑按钮
                    self.pushButton_edit8.hide() #隐藏最后2个编辑按钮
                    self.pushButton_edit9.hide() #隐藏最后2个编辑按钮
                    self.pushButton_edit10.hide()
                elif b==7:#如果有7行空白
                    self.pushButton_edit4.hide() #隐藏最后2个编辑按钮
                    self.pushButton_edit5.hide() #隐藏最后2个编辑按钮
                    self.pushButton_edit6.hide() #隐藏最后2个编辑按钮
                    self.pushButton_edit7.hide() #隐藏最后2个编辑按钮
                    self.pushButton_edit8.hide() #隐藏最后2个编辑按钮
                    self.pushButton_edit9.hide() #隐藏最后2个编辑按钮
                    self.pushButton_edit10.hide()
                elif b==8:#如果有8行空白
                    self.pushButton_edit3.hide() #隐藏最后2个编辑按钮
                    self.pushButton_edit4.hide() #隐藏最后2个编辑按钮
                    self.pushButton_edit5.hide() #隐藏最后2个编辑按钮
                    self.pushButton_edit6.hide() #隐藏最后2个编辑按钮
                    self.pushButton_edit7.hide() #隐藏最后2个编辑按钮
                    self.pushButton_edit8.hide() #隐藏最后2个编辑按钮
                    self.pushButton_edit9.hide() #隐藏最后2个编辑按钮
                    self.pushButton_edit10.hide()
                elif b==9:#如果有9行空白
                    self.pushButton_edit2.hide() #隐藏最后2个编辑按钮
                    self.pushButton_edit3.hide() #隐藏最后2个编辑按钮
                    self.pushButton_edit4.hide() #隐藏最后2个编辑按钮
                    self.pushButton_edit5.hide() #隐藏最后2个编辑按钮
                    self.pushButton_edit6.hide() #隐藏最后2个编辑按钮
                    self.pushButton_edit7.hide() #隐藏最后2个编辑按钮
                    self.pushButton_edit8.hide() #隐藏最后2个编辑按钮
                    self.pushButton_edit9.hide() #隐藏最后2个编辑按钮
                    self.pushButton_edit10.hide()
            b=b-1

##计算出货产品价格与应收款
        unitPrice1=int(data[p-1][7])
        number1=int(data[p-1][8])
        amount1=unitPrice1*number1
        paid1=int(data[p-1][9])
        receivable1=amount1-paid1

        unitPrice2=int(data[p][7])
        number2=int(data[p][8])
        amount2=unitPrice2*number2
        paid2=int(data[p][9])
        receivable2=amount2-paid2

        unitPrice3=int(data[p+1][7])
        number3=int(data[p+1][8])
        amount3=unitPrice3*number3
        paid3=int(data[p+1][9])
        receivable3=amount3-paid3

        unitPrice4=int(data[p+2][7])
        number4=int(data[p+2][8])
        amount4=unitPrice4*number4
        paid4=int(data[p+2][9])
        receivable4=amount4-paid4

        unitPrice5=int(data[p+3][7])
        number5=int(data[p+3][8])
        amount5=unitPrice5*number5
        paid5=int(data[p+3][9])
        receivable5=amount5-paid5

        unitPrice6=int(data[p+4][7])
        number6=int(data[p+4][8])
        amount6=unitPrice6*number6
        paid6=int(data[p+4][9])
        receivable6=amount6-paid6

        unitPrice7=int(data[p+5][7])
        number7=int(data[p+5][8])
        amount7=unitPrice7*number7
        paid7=int(data[p+5][9])
        receivable7=amount7-paid7

        unitPrice8=int(data[p+6][7])
        number8=int(data[p+6][8])
        amount8=unitPrice8*number8
        paid8=int(data[p+6][9])
        receivable8=amount8-paid8

        unitPrice9=int(data[p+7][7])
        number9=int(data[p+7][8])
        amount9=unitPrice9*number9
        paid9=int(data[p+7][9])
        receivable9=amount9-paid9

        unitPrice10=int(data[p+8][7])
        number10=int(data[p+8][8])
        amount10=unitPrice10*number10
        paid10=int(data[p+8][9])
        receivable10=amount10-paid10

#以下将数据库中获取的内容分别对应显示在10行内
        self.label_id1.setText(str(data[p-1][0])) #数据库是从0开始的，所以减1
        self.label_shipDate1.setText(str(data[p-1][1]))
        self.label_customer1.setText(str(data[p-1][2]))
#        self.label_sales1.setText(str(data[p-1][3]))
        self.label_production1.setText(str(data[p-1][4]))
        self.label_model1.setText(str(data[p-1][5]))
        self.label_macID1.setText(str(data[p-1][6]))
        self.label_unitPrice1.setText(str(data[p-1][7]))
        self.label_number1.setText(str(data[p-1][8]))
        self.label_paid1.setText(str(data[p-1][9]))
#        self.textBrowser_payRecord1.setText(str(data[p-1][10]))
        self.label_payRemind1.setText(str(data[p-1][11]))
#        self.textBrowser_shipTo1.setText(str(data[p-1][12]))
#        self.textBrowser_remark1.setText(str(data[p-1][13]))
        self.label_amount1.setText(str(amount1))
        self.label_receivable1.setText(str(receivable1))

        self.label_id2.setText(str(data[p][0])) #数据库是从0开始的，所以减1
        self.label_shipDate2.setText(str(data[p][1]))
        self.label_customer2.setText(str(data[p][2]))
#        self.label_sales2.setText(str(data[p][3]))
        self.label_production2.setText(str(data[p][4]))
        self.label_model2.setText(str(data[p][5]))
        self.label_macID2.setText(str(data[p][6]))
        self.label_unitPrice2.setText(str(data[p][7]))
        self.label_number2.setText(str(data[p][8]))
#        self.label_amount2.setText(str(data[p][9]))
        self.label_paid2.setText(str(data[p][9]))
#        self.label_receivable2.setText(str(data[p][11]))
#        self.textBrowser_payRecord2.setText(str(data[p][10]))
        self.label_payRemind2.setText(str(data[p][11]))
#        self.textBrowser_shipTo2.setText(str(data[p][12]))
#        self.textBrowser_remark2.setText(str(data[p][13]))
        self.label_amount2.setText(str(amount2))
        self.label_receivable2.setText(str(receivable2))

        self.label_id3.setText(str(data[p+1][0])) #数据库是从0开始的，所以减1
        self.label_shipDate3.setText(str(data[p+1][1]))
        self.label_customer3.setText(str(data[p+1][2]))
 #       self.label_sales3.setText(str(data[p+1][3]))
        self.label_production3.setText(str(data[p+1][4]))
        self.label_model3.setText(str(data[p+1][5]))
        self.label_macID3.setText(str(data[p+1][6]))
        self.label_unitPrice3.setText(str(data[p+1][7]))
        self.label_number3.setText(str(data[p+1][8]))
#        self.label_amount3.setText(str(data[p+1][9]))
        self.label_paid3.setText(str(data[p+1][9]))
#        self.label_receivable3.setText(str(data[p+1][11]))
#        self.textBrowser_payRecord3.setText(str(data[p+1][10]))
        self.label_payRemind3.setText(str(data[p+1][11]))
#        self.textBrowser_shipTo3.setText(str(data[p+1][12]))
#        self.textBrowser_remark3.setText(str(data[p+1][13]))
        self.label_amount3.setText(str(amount3))
        self.label_receivable3.setText(str(receivable3))


        self.label_id4.setText(str(data[p+2][0])) #数据库是从0开始的，所以减1
        self.label_shipDate4.setText(str(data[p+2][1]))
        self.label_customer4.setText(str(data[p+2][2]))
 #       self.label_sales4.setText(str(data[p+2][3]))
        self.label_production4.setText(str(data[p+2][4]))
        self.label_model4.setText(str(data[p+2][5]))
        self.label_macID4.setText(str(data[p+2][6]))
        self.label_unitPrice4.setText(str(data[p+2][7]))
        self.label_number4.setText(str(data[p+2][8]))
#        self.label_amount4.setText(str(data[p+2][9]))
        self.label_paid4.setText(str(data[p+2][9]))
#        self.label_receivable4.setText(str(data[p+2][11]))
#        self.textBrowser_payRecord4.setText(str(data[p+2][10]))
        self.label_payRemind4.setText(str(data[p+2][11]))
#        self.textBrowser_shipTo4.setText(str(data[p+2][12]))
 #       self.textBrowser_remark4.setText(str(data[p+2][13]))
        self.label_amount4.setText(str(amount4))
        self.label_receivable4.setText(str(receivable4))


        self.label_id5.setText(str(data[p+3][0])) #数据库是从0开始的，所以减1
        self.label_shipDate5.setText(str(data[p+3][1]))
        self.label_customer5.setText(str(data[p+3][2]))
#        self.label_sales5.setText(str(data[p+3][3]))
        self.label_production5.setText(str(data[p+3][4]))
        self.label_model5.setText(str(data[p+3][5]))
        self.label_macID5.setText(str(data[p+3][6]))
        self.label_unitPrice5.setText(str(data[p+3][7]))
        self.label_number5.setText(str(data[p+3][8]))
#        self.label_amount5.setText(str(data[p+3][9]))
        self.label_paid5.setText(str(data[p+3][9]))
#        self.label_receivable5.setText(str(data[p+3][11]))
#        self.textBrowser_payRecord5.setText(str(data[p+3][10]))
        self.label_payRemind5.setText(str(data[p+3][11]))
#        self.textBrowser_shipTo5.setText(str(data[p+3][12]))
#        self.textBrowser_remark5.setText(str(data[p+3][13]))
        self.label_amount5.setText(str(amount5))
        self.label_receivable5.setText(str(receivable5))

        self.label_id6.setText(str(data[p+4][0])) #数据库是从0开始的，所以减1
        self.label_shipDate6.setText(str(data[p+4][1]))
        self.label_customer6.setText(str(data[p+4][2]))
        self.label_production6.setText(str(data[p+4][4]))
        self.label_model6.setText(str(data[p+4][5]))
        self.label_macID6.setText(str(data[p+4][6]))
        self.label_unitPrice6.setText(str(data[p+4][7]))
        self.label_number6.setText(str(data[p+4][8]))
        self.label_paid6.setText(str(data[p+4][9]))
        self.label_payRemind6.setText(str(data[p+4][11]))
        self.label_amount6.setText(str(amount6))
        self.label_receivable6.setText(str(receivable6))

        self.label_id7.setText(str(data[p+5][0])) #数据库是从0开始的，所以减1
        self.label_shipDate7.setText(str(data[p+5][1]))
        self.label_customer7.setText(str(data[p+5][2]))
        self.label_production7.setText(str(data[p+5][4]))
        self.label_model7.setText(str(data[p+5][5]))
        self.label_macID7.setText(str(data[p+5][6]))
        self.label_unitPrice7.setText(str(data[p+5][7]))
        self.label_number7.setText(str(data[p+5][8]))
        self.label_paid7.setText(str(data[p+5][9]))
        self.label_payRemind7.setText(str(data[p+5][11]))
        self.label_amount7.setText(str(amount7))
        self.label_receivable7.setText(str(receivable7))

        self.label_id8.setText(str(data[p+6][0])) #数据库是从0开始的，所以减1
        self.label_shipDate8.setText(str(data[p+6][1]))
        self.label_customer8.setText(str(data[p+6][2]))
        self.label_production8.setText(str(data[p+6][4]))
        self.label_model8.setText(str(data[p+6][5]))
        self.label_macID8.setText(str(data[p+6][6]))
        self.label_unitPrice8.setText(str(data[p+6][7]))
        self.label_number8.setText(str(data[p+6][8]))
        self.label_paid8.setText(str(data[p+6][9]))
        self.label_payRemind8.setText(str(data[p+6][11]))
        self.label_amount8.setText(str(amount8))
        self.label_receivable8.setText(str(receivable8))

        self.label_id9.setText(str(data[p+7][0])) #数据库是从0开始的，所以减1
        self.label_shipDate9.setText(str(data[p+7][1]))
        self.label_customer9.setText(str(data[p+7][2]))
        self.label_production9.setText(str(data[p+7][4]))
        self.label_model9.setText(str(data[p+7][5]))
        self.label_macID9.setText(str(data[p+7][6]))
        self.label_unitPrice9.setText(str(data[p+7][7]))
        self.label_number9.setText(str(data[p+7][8]))
        self.label_paid9.setText(str(data[p+7][9]))
        self.label_payRemind9.setText(str(data[p+7][11]))
        self.label_amount9.setText(str(amount9))
        self.label_receivable9.setText(str(receivable9))

        self.label_id10.setText(str(data[p+8][0])) #数据库是从0开始的，所以减1
        self.label_shipDate10.setText(str(data[p+8][1]))
        self.label_customer10.setText(str(data[p+8][2]))
        self.label_production10.setText(str(data[p+8][4]))
        self.label_model10.setText(str(data[p+8][5]))
        self.label_macID10.setText(str(data[p+8][6]))
        self.label_unitPrice10.setText(str(data[p+8][7]))
        self.label_number10.setText(str(data[p+8][8]))
        self.label_paid10.setText(str(data[p+8][9]))
        self.label_payRemind10.setText(str(data[p+8][11]))
        self.label_amount10.setText(str(amount10))
        self.label_receivable10.setText(str(receivable10))

        self.label_id1.hide()
        self.label_id2.hide()
        self.label_id3.hide()
        self.label_id4.hide()
        self.label_id5.hide()
        self.label_id6.hide()
        self.label_id7.hide()
        self.label_id8.hide()
        self.label_id9.hide()
        self.label_id10.hide()

# 以下设置页面中的当前页/总页数
        self.label_cPage.setText(str(g))
        if dblen%10==0: #如果能被5整除，就说明总记录刚好是5的倍数
            tPage=int(dblen/10)
        else:
            tPage=int(dblen/10+1) #否则，就应该加1页
        self.label_tPage.setText(str(tPage))

    def reload(self):
        print("browser:reload start")
        global g
        self.pageDisplay(0,g)
        print("browser:reload finish")
    def database(self):
        print("opening database...")
        conn = sqlite3.connect('nextai.db')
        curs = conn.cursor()  #创建游标
        curs.execute("SELECT * from shipment ORDER BY shipDate DESC;") # order by按shipDate排序，DESC：逆序

        data= curs.fetchall() #将数据库全部内容读入data中
        curs.close()  #关闭游标
#        conn.commit() #保存数据库
        conn.close() #关闭数据库连接
        return data
    def rdatabase(self):
        print("opening receivable custoemr database...")
        #连接数据库进行模糊查询
        conn = sqlite3.connect('nextai.db')
        curs = conn.cursor()  #创建游标
        curs.execute("SELECT * from shipment")
        data = []
        dataTem = curs.fetchone() #data[]数组获得数据库中的全部数据
        while dataTem !=None:
            unitPrice=int(dataTem[7])
            number=int(dataTem[8])
            amount=unitPrice*number
            paid=int(dataTem[9])
            receivable=amount-paid
            if receivable>0:
                data.append(dataTem)
            else:
                pass
            dataTem= curs.fetchone() #data[]数组获得数据库中的全部数据

        curs.close()  #关闭游标
        conn.close() #关闭数据库连接
        return data
    def sdatabase(self):
        print("opening search database...")
        kword= str(self.lineEdit_search.text())
        #连接数据库进行模糊查询
        conn = sqlite3.connect('nextai.db')
        curs = conn.cursor()  #创建游标
        sql="SELECT * from shipment WHERE customer LIKE"+" "+"\'%"+kword+"%\'"
        curs.execute(sql) #sql语句只能为字符串，所以在上一行将sql的字符串添加整齐
        data= curs.fetchall() #data[]数组获得数据库中的全部数据
        curs.close()  #关闭游标
        conn.close() #关闭数据库连接
        return data
    def jumpTo(self):
        jump_g=str(self.lineEdit_jump.text())
        print("jump start")
        if jump_g=="":
            QMessageBox.critical(self,"注意","输入错误，请输入要跳转到的页码，格式为数字")
            pass
        elif jump_g.isdigit()==False:
            QMessageBox.critical(self,"注意","输入错误，请输入要跳转到的页码，格式为数字")
            pass
        else:
            ttPage=int(self.label_tPage.text())
            jump_gg = int(jump_g)
            if jump_gg > ttPage :
                QMessageBox.critical(self,"注意","输入错误，输入的数字超过最大页码了啊！")
            else:
                self.pageDisplay(0,jump_gg)
    def searchDisplay(self):
        kword= str(self.lineEdit_search.text())
        if kword=="": #如果输入的搜索项为空，则reload页面，显示全部信息
            self.reload()
        else:
            self.pageDisplay(2,1)
    def toPayCustomer(self):
        self.pageDisplay(1,1)


class MyForm ( QWidget, Ui_Form ):
    def __init__(self):
        super().__init__()
        self.setupUi(self)
        self.pushButton_jump.clicked.connect(self.jumpTo)
        self.pushButton_search.clicked.connect(self.searchDisplay)
        self.pushButton_advSearch.clicked.connect(self.reload)
        self.pushButton_toPay.clicked.connect(self.toPayCustomer)


global g # 设定当前页面全局变量 g
g=1
global databaseFlag # 设定当前页面全局变量 g
databaseFlag=0

if __name__=='__main__':
    g=1
    databaseFlag=0
    app=QApplication(sys.argv)
    b = MyForm()
    b.pageDisplay(0,g)
#    b.showBrowser()
    b.show()
    e = shipment_edit.MyForm()
    a = shipment_add.MyForm()

    b.pushButton_edit1.clicked.connect(e.handle_click1)
    b.pushButton_edit2.clicked.connect(e.handle_click2)
    b.pushButton_edit3.clicked.connect(e.handle_click3)
    b.pushButton_edit4.clicked.connect(e.handle_click4)
    b.pushButton_edit5.clicked.connect(e.handle_click5)

    b.pushButton_new.clicked.connect(a.handle_click)


    app.exec_()

